ROW TOTAL

[LeonelSanchezJr]

I have 2 rows in a report.
The across is a MONTH field.
I am currently using ON TABLE ROW-TOTAL AS 'Total YTD'

The first row contains numbers up to Dec, however, from September forward the numbers are all zeroes. So, my row total is correct.

On the second row, I have numbers forecasted thru December.
However, I only want to total up to the column before September.

Can this be done?

Thanks,

Leo ;-)

 

[focwizard]

So, you don't REALLY want a ROW-TOTAL, you want a calculation.

first off, HOW should the procedure KNOW to only add up the rows through September? Is it baed on the 'current' month?