8 Replies Latest reply on Sep 24, 2018 9:06 AM by Shinichiro Murakami

    Calculated Fields.....Grrrr

    Nic G

      Hi All,

       

      I can't get my head around these, so all I want to do is count or sum up the 1's in Open/Closed column which should add to 23.

       

      However, my "Count Open" calculation seems to be counting Numbers below the Number hierarchy, how to stop this - here's my calculation.

       

      SUM({fixed[Number]:count(IF([Open or Closed])=1 then 1 end)})

       

      Sorry can't post actual Viz.