6 Replies Latest reply on Jun 3, 2015 12:18 PM by dansan500

    Calculation using multable fields as alternate formula

    dansan500

      Title

      Calculation using multable fields as alternate formula

      Post

      I have tried using an IF statement for this but I can't make it work:

      It is a commission calculation

      If the price is <$150 then Price*30% = Commission   there is a setup field for the consignment customer that contains these fields:

      Price Level < 150 - this would be the figure entered for that consignment customer

      Price Level > 151 - this would be the figure entered for that consignment customer

      Percent < - this would be the figure entered for that consignment customer

      Percent >  - this would be the figure entered for that consignment customer

      Now what I tried to do using the IF statement was:

      IF the PRICE is < 150 then use the calculation for price level 1

      IF the PRICE is >151 then use the calculation for price Level 2

      But I could't get it to work.. Can you help, it's probably simple and I just don't know it...