Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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))
take this. BYE