Pls help, very novice user here
I have a check box called [8% Received]on a report that is referenced by a field called [8%Comm]. The expression for the [8%Comm]field is:
=IIf([8% Received]=False,0,([CPremium]+[BPremium]+[OPremium])*0.08)
This works just fine problem is - now I want the report to total all the results into a field called 8%total. I am having no luck figuring this out myself. I tried =Sum((nz([8%Comm],0)))but that didn't work. not sure about the nz function.
thanks
I have a check box called [8% Received]on a report that is referenced by a field called [8%Comm]. The expression for the [8%Comm]field is:
=IIf([8% Received]=False,0,([CPremium]+[BPremium]+[OPremium])*0.08)
This works just fine problem is - now I want the report to total all the results into a field called 8%total. I am having no luck figuring this out myself. I tried =Sum((nz([8%Comm],0)))but that didn't work. not sure about the nz function.
thanks
