Example of when to use Running Total instead of Summary?

[Montana751]

I am looking for a reason to use the Running Total feature instead of inserting subtotals?

Currently, all of my formulas are in the Detail section of the report and I insert subtotals into the Group(s) and Report Footer section for Grand Totals, thus I write 1 formula, whereas with a Running Total I would have to write 3.

Does anyone have an example of when to use a running total instead of a summary???

 

[MisterMo]

One answer is in your post, you use running total if don't want to use groups or you can use then combined with groups where you would want to summarise only specific items within a group or within the report. in the evaluate section you can choose the criterias to count summarise and so on.

eg: you get lots of records for transactions over a year (dates) and you want to count transaction for different periods, monthly or quarterly and you want the data orizontally displayed for every customer


-Mo

 

[Montana751]

Thanks for the idea. I can use it for creating "Aging" buckets on my items.

 

[lbass]

You are always better off using inserted subtotals or conditional formulas when possible, since running totals are slower. The results are ordinarily limited to displays in footer sections, because they are calculated whileprintingrecords. However, there are times when only running totals will do the job.

-LB