Null condition in color expression

[#1]

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.

[MK_QSL]

LIke this?

[quriouss]

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"