Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)))))))
One way, write another nested if condition to track out null values and assign the color white or grey to it
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))))))))
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)))))))