When doing calculations in the report footer, is there a way to ignore empty fields or possibly treat them as a zero value?
I have calculated totals in a report, when there is no data to report for that column the field is empty, but if there is an empty field in one column then subsequent calculations are effected.
=Sum([ACT]) If there is nothing to report, then this sum ends up as an empty field
=(Sum([ACT]))/(Sum([ACT])+Sum([DCSS])+Sum([CR])+Sum([HR])+Sum([IT])+Sum([MK])+Sum([OPS])+Sum([PR])+Sum([SA])+Sum([TF])) since the previous field is empty the calculation for this field will also be empty (even though there is data in other categories to display.
Thanks in advance for the help.