Colour code by expreesion

[#1]

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

[shraddha_g]

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 )))))))

[Anonymous]

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

[Anonymous]

Same topic ? Color code expression

[dsharmaqv]

post your app pls

[#6]

its not working Shraddha

Regards

charlie

[shraddha_g]

Share sample data if possible

[#8]

find the App and change the colour code by expression.

[#9]

i did  chared the app , please check it out the colour code shraddha.

Regards

Charlie

[#10]

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