Enter Parameter Value box

[Lynnjm]

I have a report that lists invoices for a months period. Some of the invoices are in US$ - so the first thing I do is convert the US$ into Cdn$. That works fine. I then want to sort out the HOLD invoices from the sent invoices. That works fine. The problem starts when I try to total, in the report footer section, the HOLD column and the <>HOLD column. I get the message "Enter Parameter Value Text31"

This is what I have for calculations in the various sections.

I would greatly appreciate somebody telling what I am doing incorrectly.

Thanks


Text31 is =IIf(([Currency])="US",(([Amount])/0.65),([Amount]))
This is in the detail section of the report

=IIf(([Comments])="HOLD",([Text31])," ")
This is in the detail section of the report

=Sum(IIf(([Comments])="HOLD",([Text31])," "))
This is in the report footer

When I run the report I get “Enter Parameter Value – Text 31”

 

[llkhoutx]

Text 31 refers to a field on ther active form, which apparently does not exist, which the code is looking for.

It was probably Text 31 when initially built and you subsequently renamed it.

 

[Rich]

You cannot Sum calculated fields, either repeat the calculation in the Sum, or use a hidden text box with the correct running sum selected i.e overall/overgroup and refer to that textbox in the footer