Hi,
I have a crosstab with the sales of actual year and last year, and have the difference between these years. This field has a conditional event to put colour in the field, if the difference between actual year and last year is greater than 0 I put green colour else red.
Furthermore I add a new field that represent the percentage between the value actual date and value last year, with this formula:
if([actual_year] is null)
THEN ([last_year]*(-1))
else if ([last_year] is null)
then ([actual_year])
else ([actual_year] - [last_year]) / abs([last_year])
And I would like to apply a conditional event to put green or red colour, anyone know how I can configure a conditional event with this criteria?
Regards