quantity break price averages
I've tried to approach this in several ways without luck. Here's the dilema;
There are 5 different quantity fields and 5 corresponding but unrelated margin fields. I wanted to evaluate and average the margins with quantities of 1 to 10, 11 to 50, 51 to 100, etc.
or ideally when inputing a new quantity a calculation field which would give a suggested margin based on the customer code.
I know this is asking a lot.