Conditional group SUM in Crystal Reports

crystal-reportsformula

I've been doing some accounting reports and have been summing up my different currencies using a formula

IE

CanadianCommissionFormula

if {myData;1.CurrencyType} = "CDN" then
    {myData;1.Commission} 
else
    0

CanadianCommissionSum

SUM({@CanadianCommissionFormula})

Then I'd just display the CanadianCommissionSum at the bottom of the report and things were great.

I've just come across the requirement to do this, but grouped by Sales Rep. I tried using my previous formula, but this sums for the whole report. Is there an easy way to sum like this, based on which group it's in?

Best Answer

You probably figured this out a year ago, but just in case, try this:

  1. Change your CanadianCommissionSum formula to

    SUM({@CanadianCommissionFormula},{SalesRep})

  2. Put this formula in your SalesRep's Group Footer section.

This should now display properly.

Related Topic