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.
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.