4 Replies Latest reply on Jan 25, 2018 11:38 PM by Humphrey Chapa

    Calculated Field

    Humphrey Chapa

      Have a if statement on my calculated field but it only gives results for the last part of if clause.. i.e only 5000, Shown below

       

      IF  ATTR([MTD Sales]) >= 5000000 THEN 20000

      ELSEIF ATTR([MTD Sales])>=4000000 THEN 150000

      ELSEIF ATTR([MTD Sales])>=3000000 THEN 12500

      ELSEIF ATTR([MTD Sales])>=2000000 THEN 10000

      ELSEIF ATTR([MTD Sales])>=1000000 THEN 75000

      ELSE 5000

      END

       

      Where could i be doing it wrong?