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

[andreasj]

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...

 

[Tom.G]

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) ² * MaxComm)=Commission Rate

Thereby squaring the effectiveness of giving a larger discount.

Cheers,
Tom