2 Replies Latest reply on Sep 10, 2018 5:06 AM by Manika Chhabra

    Count Number of True instances from Boolean

    Manika Chhabra

      I am trying to count the number of true instance from a calculated filed- Cal1: If Resolved >5 then 1 end, and then counting the true values as Windows_sum(Cal1). However, i want to use an LOD expression for some purpose but since Table Cals can not be used in LODs, I am stuck.

       

      Please Note that Sum(Cal1) doesnt work. It says you cant aggregate an aggregated value. Likewise, Cal1: Sum/Count(If Resolved >5 then 1 end) doesnt work either.