MHB How Can I Create a Commission Curve in Crystal Reports?

  • Thread starter Thread starter andreasj
  • Start date Start date
  • Tags Tags
    Curve
AI Thread Summary
The discussion centers on creating a commission curve in Crystal Reports to replace a simple straight-line formula for calculating commission rates. The user currently uses a formula that calculates commission based on maximum commission and maximum discount but seeks a more nuanced approach that reflects varying impacts of discounts on commission. They propose a 1-10 intensity curve, where lower intensities result in minimal commission reduction and higher intensities lead to significant drops. Suggestions include modifying the existing formula by adding parentheses to adjust the discount's impact, such as squaring the discount effect. This adjustment aims to create a more dynamic and responsive commission calculation.
andreasj
Messages
15
Reaction score
0
I'm trying to create a simple (well, not for me apparently) commission curve based on a few basic parameters. I can do the straight line approach, but I need a little more power. This is for an interactive report I am writing in Crystal Reports.

User currently enters Max Commission Rate and Max Discount Allowed.

Currently using the following formula:
MaxComm-(DiscountTaken/MaxDiscountAllowed*MaxComm=Commission Rate

It's a simple straight line diagonal formula, and it does work fine.

I would like to use a curve instead so I can alter the intensity of the drop in commission. The smaller the discount the less of an impact, and the larger the discount the more of an impact.

Assume my max commission is set to 10% and the max discount is set to 20%.

I was thinking of a 1-10 intensity curve.
1 intensity=straight 1-1 diagonal line. 50% discount=50% commission.
10 intensity=right angle, or no commission with any discount.
3 intensity might yield a 7% commission rate, rather than a 5% rate with the straight line calculation I'm using now.

I thought this was going to simple...
 
Mathematics news on Phys.org
andreasj said:
MaxComm-(DiscountTaken/MaxDiscountAllowed*MaxComm=Commission Rate
You are missing a ")". An obvious place to put that paren is just before the "=".
MaxComm-(DiscountTaken/MaxDiscountAllowed*MaxComm)=Commission Rate

By adding another paren you can apply some operation to the discount portion.
MaxComm-((DiscountTaken/MaxDiscountAllowed)*MaxComm)=Commission Rate

For instance you could use:
MaxComm-((DiscountTaken/MaxDiscountAllowed) 2 * MaxComm)=Commission Rate

Thereby squaring the effectiveness of giving a larger discount.

Cheers,
Tom
 
Suppose ,instead of the usual x,y coordinate system with an I basis vector along the x -axis and a corresponding j basis vector along the y-axis we instead have a different pair of basis vectors ,call them e and f along their respective axes. I have seen that this is an important subject in maths My question is what physical applications does such a model apply to? I am asking here because I have devoted quite a lot of time in the past to understanding convectors and the dual...
Insights auto threads is broken atm, so I'm manually creating these for new Insight articles. In Dirac’s Principles of Quantum Mechanics published in 1930 he introduced a “convenient notation” he referred to as a “delta function” which he treated as a continuum analog to the discrete Kronecker delta. The Kronecker delta is simply the indexed components of the identity operator in matrix algebra Source: https://www.physicsforums.com/insights/what-exactly-is-diracs-delta-function/ by...
Back
Top