1 Reply Latest reply on Jul 12, 2018 1:53 PM by Andrew Bickert

    Multiple Value Calculated Field

    Alexander Kost

      I'm trying to get a calculated field to create a value (1) given a few separate conditions.

       

      IF [Cost]="XXXX"

      AND [US]>10

      AND [DATE]<#2018-01-01#

      THEN 1

      ELSEIF [ US]>30

      THEN 1

      END

       

      Currently the calculated field is only giving me results for the second segment. Any insight as to why this isn't working or solutions would be greatly appreciated.