AnsweredAssumed Answered

Calculation using multable fields as alternate formula

Question asked by dansan500 on Jun 3, 2015
Latest reply on Jun 3, 2015 by 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...

Outcomes