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

    Unable to get Correct Count


      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


      COUNT([Case Time P1 8Hrs])



      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!