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
if(Status='Sanctioned But Not Disbursed',Blue(),
if((Today()-Date1)>=0 and (Today()-Date1)<=1,RGB for 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,Rgb For Beige )))))))
Hi,
I think (today -Date1 ) is not evaluating firstly you check ,it gives you required output or not,
Please share the more detail on this, So I will help you more on this.
Thanks
Paridhi
Same topic ? Color code expression
post your app pls
its not working Shraddha
Regards
charlie
Share sample data if possible
find the App and change the colour code by expression.
i did chared the app , please check it out the colour code shraddha.
Regards
Charlie
Same expression working for dimension, but not for colour code .... and one more in the app, measure number formatting , there is a extension variable in the app , for amount and Count , client want to see the amount in Cr format, count as default , any advice , PFA the app, and the extension also sharaddha
Help is Appreciated
Thanks in Advance
Charlie