Can't get total to work

  • Thread starter Thread starter Tracy
  • Start date Start date
T

Tracy

I have a report that is sorted by Customer. In the detail
of the report I have work order cost information. I also
have a sub report that brings in invoice information.

At the detail level I perform a calculation that looks
like this, I have named this text box Real1. This
calculation tells me how much money we made/lost on each
work order.
=IIf([tah_invoice_for_real].[Report]![Orig_invoice_Amt] Is
Null,0,[tah_invoice_for_real].[Report]![Orig_Invoice_Amt]-
[job_total])

In the Customer footer, I am trying to take the total for
all the jobs the customer has and perform the same
calculation at the footer level. I have tried using =sum
([Real1]), but when I run the report, I then get asked for
the parameter of Real1.

Any ideas?
 
If you had created the real1 variable in the undrerlying
query it would havve worked.
if in the reoport footer you now make the source Sum(=IIf
([tah_invoice_for_real].[Report]![Orig_invoice_Amt] Is
Null,0,[tah_invoice_for_real].[Report]![Orig_Invoice_Amt]-
[job_total]))
You'll get what you want.
FOns
 
Back
Top