AnsweredAssumed Answered

quantity break price averages

Question asked by MikeEdwards on Sep 20, 2011
Latest reply on Sep 20, 2011 by MikeEdwards


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.