Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a straight table which shows the sum of a field by date, and sorted by date.
I want to show if the current value is higher or lower than the proceeding date value using the visual clues - is this possible? I want it to go green if it higher or red if it is lower.
Hi,
Maybe use something like this in Background color box;
=if(RowNo()=1,null(),
if(above(sum(mea))>sum(mea),
Red(),Green())
)
Cheers,
Chris.