I neeed to be able to change the indicator colour depending on a previous figure from an expression. I named the expressions, previous column expression label = per1 and the new expression in the next column label is called perlast1. I have gone to values and states and attempted to add an expression in the colour fx as:

I have the indicators showing with this but they are just green regardless pointing upwards, think this be because its reading the start and end default values for the colours. I set the Value field at the top to closed date, assuming I still need a value field? Any idea? nearly there I think...just not changing the arrouw according to the code...I've added the below code into each arrow indicator down, right and up but it still seems to be reading the default values to the right??

Can you point me in the right direction to start with that?All 3 arrows have this codeAre you saying it wont read the expression value with this to see if its highter or lower...I just wanted to have if expression 2 is higher/lower than expression 1 change the arrow.

Yeah, 2 rows with the 2 expressions each under a different column. 4 expression altogther as I'm doing the same thing twice for different criteria but if it works on one row it will work on the other. Cant send a screenshot here cant see anywhere to add attachment.

I just noticed that I had brackets around the fist expression and when I removed these the colours correctly changed, now the arrows seem to be working but they are not changing shape, always pointing upwards. for example the figure for yesterday is the same for today for the first expression and the colour is orange which is good but the arrow is still pointing upwards instead to the right. I entered the code into all 3 arrow indicators, one for up, down and right? maybe I need to split the code into each arrow...

and one for the icons like this:--arrows=IIf((ReportItems!per1.Value) > ReportItems!per2.Value,"ArrowUp",(IIf(ReportItems!per1.Value < ReportItems!per2.Value,"ArrowDown",(IIf(ReportItems!per1.Value = ReportItems!per2.Value,"ArrowSide","ArrowSide")))))