8 Replies Latest reply: Jan 14, 2013 3:29 AM by christmaslovesr RSS

    Problem with Null Values

      Hi Guys,

       

      I have a scenario, my expression is: count(A)+count(B).

       

      If count(A) is null, the expression returns null even if count(B) has a value.

       

      By right, I want the expression to return the value of count(B) whenever count(A) is null.

       

      Can anybody suggest a solution to this problem?

       

      Thanks