Totaling Conditional Formulas

[kassea]

I am using Crystal Reports 2008. I have a report grouped by City with each City having a different freight rate. I am using an If Then formula to calculate the freight cost for each City ([Pounds] * Rate). How can I get a grand total of the freight cost? Thank you.

 

[pmax9999]

Does a simple "Sum" summary (right click on the formula, Insert=>Summary) of the formula not work? If its a simple If-Then-Else is will but if it includes variables, running totals etc you will need to use Variables.

In need, please post a copy of that formula and we can explain how to use it with variables.

Cheers
Pete

 

[kassea]

Here is the formula I am using to calculate the freight:

if{SHIP_TO_INFORMATION_T.SHIP_TO_CITY} IN ["ANNISTON"] THEN {#rt cytd Pounds CITY} * .225
ELSE IF {SHIP_TO_INFORMATION_T.SHIP_TO_CITY} in ["INDIANOLA"] THEN {#rt cytd Pounds CITY} * .215
ELSE IF {SHIP_TO_INFORMATION_T.SHIP_TO_CITY} in ["QUINCY"] THEN {#rt cytd Pounds CITY} * .27

 

[SkipVought]

hi,

IMNSHO, a nexted if is one of the worse methods to use to do this sort of logic!

This data is best stored in a table for lookup of for joining in your query.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[pmax9999]

kassea

It is because you are using Running Totals which you could very easily have avoided by calculating the Freight at the record (detail) level and using simple a Summary to subtotal at the City level and at the Grand Total level.

Anyway, to obtain a Grand Total using your existing approach, replace your formula with the following:

WhilePrintingRecords;
Local NumberVar CF :=
if{SHIP_TO_INFORMATION_T.SHIP_TO_CITY} IN ["ANNISTON"] THEN {#rt cytd Pounds CITY} * .225
ELSE IF {SHIP_TO_INFORMATION_T.SHIP_TO_CITY} in ["INDIANOLA"] THEN {#rt cytd Pounds CITY} * .215
ELSE IF {SHIP_TO_INFORMATION_T.SHIP_TO_CITY} in ["QUINCY"] THEN {#rt cytd Pounds CITY} * .27; 

Global NumberVar TF := TF + CF;

CF

Then, place the following formula in the Report Footer:

WhilePrintingRecords;
Global NumberVar TF

Hope this helps.

Cheers
Pete

 

[kassea]

This worked perfectly!! Thank you, Pete.