I have a few formulas that seem to be working well apart from one thing. I have a subreport and can successfully pass a value to them ain report. This value then goes into a formula that acts as a running total. The problem is that the running total seems to add the final value twice when I put this into a group. E.g.

A           B    C    
1.00      3    1.00                    
15.50    5    16.50                        
0.00      1    16.50        
0.00      1    16.50                        
24.00    2    40.50    
                
Total in Details Section:    40.50               
Total in Group Section:    64.50                   

Where col A is the value passed from the subreport, and C is the cumulative total. Ignore B! The maths from this indicates that as soon as the total enters the group, it redoes that final addition.

Is this an inherent problem with doing thins this way? Or have I missed something?
Thanks!                           

CODE:
SubReport:
//@SubFormula
//Stores the value of the {@TAT_AvTAM} field
//in a number variable called 'myTotal'

WhilePrintingRecords;
Shared NumberVar myTotal := {@TAT_AvTAM}


Main Report:
//@MainFormula
//Returns the value that was stored
//in the shared number variable called
//myTotal in the subreport

(WhilePrintingRecords;
Shared NumberVar myTotal;
myTotal )

Display Field – this is used to pass the above value to an accumulator field. This can then be used for calculations.
WhilePrintingRecords;
NumberVar TotalTAT:= {@TAT_SubReportLink} + TotalTAT;
 

I created a new formula to reference this (TAT_SubReportLink) which contains:
(WhilePrintingRecords;
Shared NumberVar myTotal;
myTotal )
form the above. I putthat in to try and get my aching head around the While loops... but you are right. If I substitute the following it also works.

WhilePrintingRecords;
//NumberVar TotalTAT:= {@TAT_SubReportLink} + TotalTAT;
Numbervar TotalTAT := TotalTat + Shared NumberVar myTotal;

However, the error still occurs. The subreport value is in the detail section also. Is there a way to temrinate the while loop after the last vlaue? It's almost as if the forumula when it appears in a group does the same calaculation again, and takes the cumulative total and adds it to the last value. This thing works great as long as the forumula stays in the detials section.

Edited by skinfreak - 04 Aug 2009 at 1:13am