Sum on a report with criteria

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

Guest

I have one field in the detail section of a group header. It's one field with a descriptor that will change, Ex Amount Written Off or Amount Recovered. I would like to sum the amounts written off and the amounts recovered in the report footer. For example, I think the formula must go something like this:
=Sum([SumOfAmount]IIF([Response lbl] = "Written Off"))
But that doesn't work.
Basically, I'm trying to Sum Field A only if Field B equals N, how can I do this? Please help :)
 
S said:
I have one field in the detail section of a group header. It's one field with a descriptor that will change, Ex Amount Written Off or Amount Recovered. I would like to sum the amounts written off and the amounts recovered in the report footer. For example, I think the formula must go something like this:
=Sum([SumOfAmount]IIF([Response lbl] = "Written Off"))
But that doesn't work.
Basically, I'm trying to Sum Field A only if Field B equals N, how can I do this?

I think you want:

=Sum(IIf( = "N", [A], 0))
 
Back
Top