Symptom
When using a forumla to work as a running total in the details section the last value is duplicated when the formula is displayed as a total in the footer.
Reproducing the Issue
Have a formula that consists of a running total and a shared variable, such as:
shared numbervar mastersum;
mastersum:=mastersum+tonumber({Account.Account Number});
Cause
Resolution
Create a second variable that will run "behind" the one that adds and use that one to display, an example being:
shared numbervar mastersum;
shared numbervar finalsum;
mastersum:=mastersum+tonumber({Account.Account Number});
finalsum:=mastersum;
And then a second formula for the footer that would consist of:
shared numbervar finalsum;
finalsum;
Keywords
last value, sum, running total , KBA , BI-OD-CR , CrystalReports.com , Problem