Percent column with conditional style

[erjorgea]

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