1 Reply Latest reply on Feb 3, 2016 5:43 AM by Steve Taylor

    Need help in counting nulls  and zero in the measure.

    rushendra sriram

          I have tried writing this below codes but i did not the get the count of nulls.

       

      IF STR([Division]) = 'null' Then 'A' ELSEIF [Division] = 0 THEN 'B' ELSE 'C' END i am getting the counts for zero not for nulls.

       

      Please help in getting to solve.

       

      Thanks

      Rushi.