13 Replies Latest reply on Apr 25, 2018 5:04 PM by Zhouyi Zhang

    I want to create a calculation that counts the Total days of [audit timestamp] over 90% occupancy

    Jordan Beckford

      COUNTD( DATEPART('day',[Audit Timestamp])) WHEN([% of Occupancy (for pie chart)]) >= .90 ELSE Null END))

       

      is what i came up with but im getting a syntax error