2 Replies Latest reply on Dec 12, 2016 7:49 PM by Christopher McKinnish

    IF - AND Calculation

    Christopher McKinnish

      IF [Numeric Key 2] = 1.0 and [Numeric Key 1] = 2200 THEN [ 2200  FIELD] ELSEIF 

      [Numeric Key 2] = 1.0 and [Numeric Key 1] = 500 THEN  [0500 FIELD] ELSEIF

      [Numeric Key 2] = 1.0 and [Numeric Key 1] = 1800 THEN [1800 FIELD] ELSE "ERROR"

      END

       

       

      Anyone venture a guess as to why this calculation is returning the following error?

       

      [Expected Type Integer, found string. Results types from 'IF' expression must match.]

       

      Every one of my data fields are numeric?