Total a Calculated field? (1 Viewer)

[Sneale]

Hello,

I am trying to get a total amount in the footer of my report. I have a calculated field called txtGCTotal that has the following expression: =IIf([NotEligible]=False,50,0)+(Nz([SumOfPointAmt])*2). I have tried adding a text box in the footer with the expression =Sum([txtGCTotal]) but it returns an error. Am I missing something?

 

[June7]

This is not a field, it is a textbox. Aggregate functions must reference fields, not controls. You will have to repeat the expression in the Sum() function.
=Sum(IIf([NotEligible]=False,50,0)+(Nz([SumOfPointAmt])*2))

Or do this calculation in query and reference that calculated field in the Sum().

 

[arnelgp]

you can also Reduce the expression:

IIf([NotEligible]=False,50,0)

To

50+[NotEligible]*50