How to Perform a Calculation for each Detail Record

[John Baker]

There is probably a simple solution to my problem but I just can't seem to figure it out!

I have a report that is based on a Crosstab query. The query counts problem management tickets for each business unit location by status (open, updated, closed).

In my report, I would like to provide a TOTAL for each detail record, that totals all problem management tickets for each business unit location.

The report is laid out in this format:

Location #open #updated #closed total

I am able to 'sum' the #open, #updated, and #closed in the report footer; however, I cannot figure out how to build the expression to calculate totals for each detail record.

Any help or insights would be appreciated!

Thanks,
John

 

[John Baker]

Solution Found

My total calculation was not working because some of the values were null. I used the 'Nz' function in my expression and the TOTAL field calculates perfectly now.

=Nz([open],0)+Nz([updated],0)+Nz([closed],0)