4 Replies Latest reply on Oct 11, 2016 10:19 AM by David Li

    How do I create a COUNT IF statement using two fields?

    Yvette Jones

      I am trying to get a total count using a COUNT and an IF statement in order to get a total for each record that has a severity rating greater than 7.

       

      This is the statement that I created however I continue to get different errors on it:

      COUNT([Record Number]):then (IF [Severity Rating]>7 then 1 else 0 end))