0
Former Member
Dec 21, 2010 at 06:35 PM

# Running total of another running total ( or some other solution )

171 Views

I posted in my previous thread that I would like to be able to do rounding at the subtotal level and then have a total of these subtotals. Here is the original thread:

totals in a cross tab report

So I was told that with the cross-tab report I can either do rounding at the details level or at the final total level. However, I need to be able to do the following:

Suppose I receive payments from different states. In my report I would like to be able to display:

- a total of all payments for one given state, rounded to whole dollars - this one is easy because I just create a running total for the payments and then at the end I round it to whole dollars

- a total of all payments and all states as one number. However, the problem I can't figure out here is that this grand total needs to be calculated as the SUM of the totals for each state where the total for each state is rounded to a whole dollar before being added to the grand total. So the rounding should not be done on the final grand total but rather:

1. calculate the total of payments for one state and round it to a whole dollar - let's call it StateTotal ( rounded)

2. calculate the SUM of all StateTotal values. So it needs to be a SUM of the already rounded state totals.

Any help will be greatly appreciated.

thanks