9 Replies Latest reply on Oct 17, 2016 12:41 PM by Alex Xu

    I really need help on creating an "if" statement

    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.

       

      I have tried using filters as well as I tried the following statements however I continue to get different errors on it or the outcome is incorrect:

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

      COUNT([Record Number]) if [Severity Rating]>7 then 1 elseif <8 then 0 end end