Using the Summary expert, you just do a grand total.

 

In this case you're not summing the group totals, you're summing all of the detail data that goes into making the group totals.

 

-Dell

  I have created a Running Total to evaluate on a formula and to reset on each order. The Running total is working fine.

Now i want to use this Running total in another formula. but when i went to formula editor, i can't find this running total? Anyone know how i could solve this issue?

I created the Running total to create a Std Cost for each order based on a certain criteria. I then wanted to compare Actual cost for each order against the result of this running total by comparing the Actual Cost minus Std Cost (Running Total) to get a variance Total