
1. Re: Calculation using multable fields as alternate formula
philmodjunk Jun 3, 2015 10:51 AM (in response to dansan500)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.

2. Re: Calculation using multable fields as alternate formula
dansan500 Jun 3, 2015 11:08 AM (in response to dansan500)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

3. Re: Calculation using multable fields as alternate formula
philmodjunk Jun 3, 2015 11:14 AM (in response to dansan500)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.

4. Re: Calculation using multable fields as alternate formula
dansan500 Jun 3, 2015 11:19 AM (in response to dansan500)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.

5. Re: Calculation using multable fields as alternate formula
philmodjunk Jun 3, 2015 11:28 AM (in response to dansan500)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.

6. Re: Calculation using multable fields as alternate formula
dansan500 Jun 3, 2015 12:18 PM (in response to dansan500)Thank you, very much your first answer worked perfectly