Background color should ignore to Null Values

[krishna20]

Hi Folks,

I am writing a background color expression and it's working fine. But, the color is allocating to Null values also, It's taking else condition's RGB().Expression should ignore when value is Null ( -) .

How can I achieve it, please look into the below expression and screenshot for the same and advise me.

Expression:

if($(vACD_Ag_RNA)<='5.0',RGB(255,255,125),

if( $(vACD_Ag_RNA)>'10.0' and $(vACD_Ag_RNA)<='15.0'  ,RGB(255,255,102),

If($(vACD_Ag_RNA)>'15.0' and $(vACD_Ag_RNA)<='40.0', RGB(255,255,0),

if($(vACD_Ag_RNA)>'40.0' and $(vACD_Ag_RNA)<='60.0' ,RGB(204,255,153),

if($(vACD_Ag_RNA)>'60.0' and $(vACD_Ag_RNA)<='85.0' ,RGB(153,255,51),

if($(vACD_Ag_RNA)>'85.0' and $(vACD_Ag_RNA)<='100.0',RGB(0,255,0), RGB(97,193,0)))))))

Image :

Thanks

Krishna

[Anonymous]

One way, write another nested if condition to track out null values and assign the color white or grey to it

[Clever_Anjos]

Maybe

IF(isnull($(vACD_Ag_RNA)),white(),

if($(vACD_Ag_RNA)<='5.0',RGB(255,255,125),

if( $(vACD_Ag_RNA)>'10.0' and $(vACD_Ag_RNA)<='15.0'  ,RGB(255,255,102),

If($(vACD_Ag_RNA)>'15.0' and $(vACD_Ag_RNA)<='40.0', RGB(255,255,0),

if($(vACD_Ag_RNA)>'40.0' and $(vACD_Ag_RNA)<='60.0' ,RGB(204,255,153),

if($(vACD_Ag_RNA)>'60.0' and $(vACD_Ag_RNA)<='85.0' ,RGB(153,255,51),

if($(vACD_Ag_RNA)>'85.0' and $(vACD_Ag_RNA)<='100.0',RGB(0,255,0), RGB(97,193,0))))))))

[Anil_Babu_Samineni · Accepted solution]

We have one option like, But usually It won't effect for null values

If(IsNull($(vACD_Ag_RNA)), White(),

if($(vACD_Ag_RNA)<='5.0',RGB(255,255,125),

if( $(vACD_Ag_RNA)>'10.0' and $(vACD_Ag_RNA)<='15.0'  ,RGB(255,255,102),

If($(vACD_Ag_RNA)>'15.0' and $(vACD_Ag_RNA)<='40.0', RGB(255,255,0),

if($(vACD_Ag_RNA)>'40.0' and $(vACD_Ag_RNA)<='60.0' ,RGB(204,255,153),

if($(vACD_Ag_RNA)>'60.0' and $(vACD_Ag_RNA)<='85.0' ,RGB(153,255,51),

if($(vACD_Ag_RNA)>'85.0' and $(vACD_Ag_RNA)<='100.0',RGB(0,255,0), RGB(97,193,0))))))))

OR

if($(vACD_Ag_RNA) >= '0.0' and $(vACD_Ag_RNA)<='5.0',RGB(255,255,125),

if( $(vACD_Ag_RNA)>'10.0' and $(vACD_Ag_RNA)<='15.0'  ,RGB(255,255,102),

If($(vACD_Ag_RNA)>'15.0' and $(vACD_Ag_RNA)<='40.0', RGB(255,255,0),

if($(vACD_Ag_RNA)>'40.0' and $(vACD_Ag_RNA)<='60.0' ,RGB(204,255,153),

if($(vACD_Ag_RNA)>'60.0' and $(vACD_Ag_RNA)<='85.0' ,RGB(153,255,51),

if($(vACD_Ag_RNA)>'85.0' and $(vACD_Ag_RNA)<='100.0',RGB(0,255,0), RGB(97,193,0)))))))