Adding up two separate Running Totals 1

[gamble1]

Hello,

I have two separate Running Totals in my report. I now need the Sum of those two Running totals. What's the best way to handle that?

Each Running Total has it's own set of criteria and I'm having a hard time - 'merging' the two sets. Make sense?

Thanks!

 

[alley211]

Sometimes depending on what you have done, you could create a formula and add the two running totals within the formula.

If this doesn't work, have you tried using variables instead?

alley

 

[dgillz]

are you talking about 2 running totals, or one running total with multiple levels of grouping?

For example, I have a Sales History report that groups by Item within Item Family. I created one running total for Item Qty On Hand, evalaute on change of group item, reset on change of group Item to get my qty on hand once for that item instead of once for every sales history record.

I have another running total for Item QOH, evaluate on change of group Item, reset on change of group Item Family to get my total qty on hand for that Item Family.

I have a third running total item QOH, evaluate on change of group Item, reset=never to get my grand total on hand.

Food for thought. Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office