Calculating Totals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've created a report and in the group footer I have listed:
Reserves, Payments, Incurred. Each category has a total. The Incurred total
is the Reserves + Payments, but how do I put that in a formula where it
automatically calucates that for me?

Also I have on another report in the group footer:
Reserves, Payments, Recovery, Incurred. What type of formula do I use if I
want the Reserves + Payments - Recovery to = Incurred? Thanks so much
 
I've created a report and in the group footer I have listed:
Reserves, Payments, Incurred. Each category has a total. The Incurred total
is the Reserves + Payments, but how do I put that in a formula where it
automatically calucates that for me?
Click to expand...

Try this.
In the control source for "Incurred" text box control enter the following
expression.

=sum(Nz([Reserves]) + Nz([Payments])
Also I have on another report in the group footer:
Reserves, Payments, Recovery, Incurred. What type of formula do I use if I
want the Reserves + Payments - Recovery to = Incurred?
Click to expand...

for the above, in the control source for "Incurred" text box control enter as
given below.
=Sum(Nz(reserves] + Nz([Payments]) - Nz([Recovery]))

If you want to know the use of Nz function, visit the site
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaac11/html/acfctNZ_HV05186465.asp


Surendran
 
Back
Top