Sum total

tikkat3

Registered User.
Local time
Today, 11:26
Joined
Apr 10, 2007
Messages
66
Hi,

I have incorrect results in one of my reports. In the report footer I have the running sum results of a calculation in the Detail section of the report. This works fine in all but one column.

The problem column provides the results of [Column B] - [Column A]. The footer calculation should be the running sum of the B-A line results. However, in a number of instances there is no data input into the individual lines in Columns A and B. Therefore the footer results are not adding up.

Any suggestions? Thanks.
 
look up how to use the NZ function
 

Users who are viewing this thread

Back
Top Bottom