I don't understand this part of your description:
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
Going by your example calculation, this would be one value, not two, the $150 shown in your first example.
It seems like you need:
If ( Price < Price Level ; Price * PercentLT ; price * PercentGT )
This assumes that the two percent fields store percent in decimal format. 50% would be stored as 0.5.
we usually get from the consignee numbers like this:
If you sell something that is priced under (SELLING PRICE) then we will give you 50% percent commission
If you sell something that is priced over (SELLING PRICE) then we will give you 30% percent commission.
I need for program to make that distinction and then do the formula
Exactly. But "Selling Price" is then exactly the same value in both of those sentences correct? If they were different, you'd need three percent commission rates instead of two. The third rate would be for prices greater than the first selling price and less than than the second selling price.
that is correct, the Selling Price is one price that comes from the sales order. Depending what that number is will determined the formula used to get the answer.
Yet in your original example you had a place for two price levels. Given your last post here, my example in my original post should be sufficient to do what you have requested.
Thank you, very much your first answer worked perfectly