7 Replies Latest reply on Apr 10, 2018 1:36 PM by Jim Van Sistine

    Add additional criteria to a calculated field

    Bill Benton

      Here is the current calculation for the field:

      I want to add another criteria element that distinguishes CLASS (another field) to either PPA or CA in which 1 represents PPA and 3 CA.


      I thought that adding AND at the end of the above e.g. AND (IF  [Class] =1 THEN ......


      Now I'm stuck.