Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have two measures, Test and Compare. I want to change the color of my chart based on whether Test>Compare or not. However there are some null values in Test.
My expression if(sum(Test)>sum(Compare),red(),green()) does not work because of the null values in Test. Is there a way to add the null condition into my if statement?
Thanks.
LIke this?
You'd think so, wouldn't you. Unfortunately it doesn't seem to work for me (although I suspect this might be dependent on data-source).
In my data-load script I specifically have to test for NULL values and replace them with zeroes;
IF(ISNULL("[IPH29NKH]") , 0 , "[IPH29NKH]")) as "Invoice Value"