13 Replies Latest reply: Jan 30, 2015 10:59 AM by Rupesh Bharadwaj RSS

    Error in Calculation in Set Analysis Expression of a Pie Graph

    Leonardo Lopez

      Good Morning Everyone, I have a problem in one pie graph where I have one set analysis expression to calculate a distribution by a given variable.

       

      With this expression I create my first distribution where Status=1

       

      count({<Rc={'D','K'}, Status={1}>} ID)

       

      Here is the problem, with the following expression, I want to create a distribution with Status<>1, but sometimes Status could be Null. Then the expression does not consider this value, and I do not have all the registers.

       

      count({<Rc={'D','K'}, Status-={1}>} ID)


      Thanks for your help.