Calculation in a report footer

[Liz C]

Hi!
I have a calculated field in the detail section of a report. The calculation
is
=IIf([ContractNo]=10000007,(Sum([CurrentIEst])+Sum([PriorIAct])+Sum([PriorIEstNew]))*1.0177,Sum([CurrentIEst])+Sum([PriorIAct])+Sum([PriorIEstNew]))
When I try to total this at the group footer level, I used
=IIf([ContractNo]=10000007,(Sum([CurrentIEst])+Sum([PriorIAct])+Sum([PriorIEstNew]))*1.0177,Sum([CurrentIEst])+Sum([PriorIAct])+Sum([PriorIEstNew]))
and it worked fine, but when I try to use the same thing at the report footer
level, it doesn't give me the correct total (it acts as if none of the
contracts are 10000007 and one is).

Any ideas?

Thanks in advance for your help!

 

[Liz C]

Never mind - I used Knowledge Base Article Q129096