The scenario is: I have two records coming in to the report.

 

Record #1 ServiceInfo = 111122223333 , Rate= 170.00

Record #2 ServiceInfo = 111122223333 , Rate= 170.00

 

The report is group by ServiceInfo.  So, the report displays only one record which is what I want.  I also want to keep summary of the rate.  So, I created a formula field to add up the rate.  In this case, my formula TotalRate should add up to be a total of 170 but my report display 340.

 

My formula field looks like this:

 

Whileprintingrecords;
Numbervar TotalRate;
TotalRate := TotalRate + Sum ({@SharedRate}, {ServiceInfo});

 

Help please!

 

Thanks!