before Function

[darrellbutler]

Hi,

I'm trying to highlight values in a table that are less than the previous day. My horizontal dimension is date however the following doesn't seem to work

if(columnno()>0 and rowno()>0,if(before([CONFIRMED_FORECAST_TONNES],1,0)<[CONFIRMED_FORECAST_TONNES],rgb(255,198,198),rgb(198,255,198)),rgb(255,255,255))

any ideas why this maybe the case ?

rgds

Darrell.

[rajni_batra]

TRY

if(columnno()>0 and rowno()>0,if([CONFIRMED_FORECAST_TONNES]<previous([CONFIRMED_FORECAST_TONNES]),rgb(255,198,198),rgb(198,255,198)),rgb(255,255,255))

[#3]

take this. BYE