Report Sum adding values from 4 different fields

[Marge Barest via AccessMonster.com]

I am adding the values of four fields in one formula for a report. The
formula is below. The formula works when I only add the first two fields
("Sec_Sur1_age_range" and "Sec_Sur2_age_range"). However, when I try to
add the third and fourth parts, the value in the report comes out blank.

Any advice will be greatly appreciated. Thanks for the help.

=((Abs(Sum([Sec_Sur1_age_range]="Elderly_65+")))+(Abs(Sum(
[Sec_Sur2_age_range]="Elderly_65+")))+(Abs(Sum([Sec_Sur3_age_range]
="Elderly_65+")))+(Abs(Sum([Sec_Sur4_age_range]="Elderly_65+"))))

 

[Ken Hudson]

Hi,
It could be that these last fields have null values in them.
Try adding the "nz" function to your formula:

.....nz(Abs(Sum([Sec_Sur4_age_range]="Elderly_65+))),0)

Cheers