• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3262
  • Last Modified:

Difference between total types

What is the difference between a GrandTotal and an Running Total?

what about a subtotal, etc.?
0
dba123
Asked:
dba123
  • 3
3 Solutions
 
mlmccCommented:
I am not really sure since I haen't used grand totals.

A quick check of my reference.
Grand totals and subtotals are for hierachical data.

Grand Total - Total of all records selected.  I suspect can only be used in a summary fasion.
Subtotal - Total for a group.  I suspect can only be used in a summary fashion.

Running totals - You control the type and execution.  You can use these to show a running total for each detail line.  Can control which records get used via formulas.

mlmcc
0
 
frodomanCommented:
As mlmcc said, you have a great deal of control over a running total.  A subtotal and grand total are automatically generated and you don't have control over when they're reset and what gets added to them and what doesn't.

You can use a running total to generate a subtotal or to generate a grand total.  For example a running total which sums all records and resets it's value whenever the group changes is in effect generating subtotals.  A running total which does the same thing but never resets it's value is generating a grand total.

Does that help or is there a specific situation you're trying to work through?

frodoman
0
 
mlmccCommented:
0
 
mlmccCommented:
Glad i could help

mlmcc
0

Featured Post

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now