Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all ,
does the following code is correct? not working actually
if(Status='Sanctioned But Not Disbursed',$(Blue),
if((Today-Date1)>=0 and (Today-Date1)<=1,$(Pink),
if((Today-Date1)>=2 and (Today-Date1)<=3,$(Yellow),
if((Today-Date1)>=4 and (Today-Date1)<=5,$(Green),
if((Today-Date1)>=6 and (Today-Date1)<=14,$(Blue),
if((Today-Date1)>=15 and (Today-Date1)<=30,$(Blue),
if((Today-Date1)>=31,$(Beige))))))))
Any Advice
Regards
Charlie
create your Day buckets during data load, and then refer them in the Color expressions
example
Pick(Match(DayBucket,'0-1 Days','2-3 Days',.........),red(),green(),......)
use num function in your expression like below
If(num(Today())-num(Date1)>=1,Red(),Blue())