SUM Conditional Group in Crystal Reports

Question

I do some accounting reports and summarize my different currencies using the formula

IE

CanadianCommissionFormula

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

CanadianCommissionSum

SUM({@CanadianCommissionFormula})

Then I just show the CanadianCommissionSum at the bottom of the report, and everything was great.

I just stumbled upon a requirement to do this, but grouped in Sales Rep. I tried using my previous formula, but these are the sums for the whole report. Is there an easy way to summarize this based on which group it is in?

Answer 1

You probably understood this a year ago, but just in case, try the following:

• Change the formula CanadianCommissionSum to

  SUM({@CanadianCommissionFormula},{SalesRep})

• SalesRep.

.

Answer 2

, Crystal Report, :

SUM({@CanadianCommissionFormula})

... .

Answer 3

, rexem , , , . , , .

, Sales Rep, reset . , .

, .