3 Replies Latest reply on Nov 14, 2018 3:43 PM by Yeheyies Tekleselassie

    Countd Null Value Dimension

    Yeheyies Tekleselassie

      Hello,

       

      Please help

       

      I used different cals to identify to count the null value of the dimension.

       

      COUNTD(IF [Status Description]<>"" then 1 else 0 end )   - Not working  also used COUNTD(IF ISNULL([Event Type]) then [Child Plus ID] END) but not working.

       

      COUNTD(IF [Status Description] ="Failed" THEN [Child Plus ID] END)            Works

      COUNTD(IF [Status Description] ="passed" THEN [Child Plus ID] END)         Works

       

      The Status Description has three values  Passed, Failed, and Null (which means no data entered).  The above cal gave me 1 value for all the students.(see img).  Thank you

       

      The total number of student is 16. 5 Failed, 7 Passed and 4 supposed to be Null (1 value)

       

      Thank you for the help.

      Icy