Override of a Parameter Field

[wilekoyote76]

I am writing a report with CR11 and the company I am doing this for has a quirky way of doing calculations. They have several conditionals and variables that are used based on which vendor is being used and the specifics of the job.

What I am trying to account for is a automatic selection for the Commission_Percentage with an override that can be added for the other circumstances but for that one record only, not the Grouped Selection. Manual change in one of the calculations for License_Commission*Commission_Percentage would be needed to override the Grouped Selection.

Is there a way to do this?

Please ask any questions related as I will do whatever I can to assist in explaining.

 

[chelseatech]

Create a formula for Commission rate and set the rules for the calculation there.

A simple If - then else should cover all the options;
if {Table.CustNo}= "12234" then .10 else
if {table.CustNo}="4567" then .12 else .75
Just need to be clear on what the rules are for each commission rate

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[wilekoyote76]

The only thing is, as the customer says "it depends". Apparently they have situations where it will be different at times and it needs to be altered based on the "exception". The only thing is..the exception doesn't happen all the time even with the same customer number.

A real life example in this scenario would be this:

A "claim" comes in from the client and is assigned to an adjuster. First, each adjuster gets different rates, but don't worry about that portion as I have that figured out already. However, sometimes these claims need to be closed early and only billed "partially" for the time and expense rather than the flat rate. Other times, the claims need to be "reopened" or "reinvestigated" and what normally would be paid out to the adjuster is now downgraded to 20% of the pay on the reopen/reinvestigate. Yet all the other claims are paid out at the normal pay.

 

[lbass]

Maybe add in parameters into the formula that Chelseatech suggested, as in:

if {table.custno} = {?SpecialCustomer} then
{?Specialrate} else
if {Table.CustNo}= "12234" then
.10 else
if {table.CustNo}="4567" then
.12 else
.75

-LB