5 Replies Latest reply on Jan 15, 2016 4:27 AM by Derrick Austin

    Unable to get Correct Count

    fauzia.jalali.0

      Hi All,

       

      I am trying to do simple calculation but some how its not working. I have a column called [Case Time P1 8Hrs], it has 1's and 0's.

      My Goal is  get percentage of 1's . Which is [(Count of 1s)/(Total count ie 0s + 1s)]*100

       

      So first I try to get count of 1's by creating formula called [Count_1]

      CASE(ATTR([Case Time P1 8Hrs])) WHEN 1

      THEN

      COUNT([Case Time P1 8Hrs])

      END

       

      then i just do [Count_1]/  COUNT([Case Time P1 8Hrs])

       

      I get blanks. Actually my Count_1 is not getting calculated properly, not sure why. Kindly Advice!

       

      PFA! Thanks a lot!