11 Replies Latest reply: Jun 24, 2015 1:28 PM by Simon Hogg RSS

    Null condition in color expression

      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.