How to get a total for only one item type in a column...

[BEstes]

Hello,



I have a report, that lists all active and inactive documents for my company. I need to have a total at the bottom of the report that displays the total for the active documents. There is a column that shows a 1 for active docs and a 2 for inactive docs. No matter what I try, I can't get a total for only the lines with a 1 in this column. Any help I could get with this would be VERY appreciated.

[pbaldy]

=Sum(IIf(ActiveFieldName = 1, 1, 0))

[BEstes]

Thanks for your response, whenever I enter that I get this error message.



I am entering =Sum(IIf([Status]=1,1,0))

Now it's just a matter of figuring out what I did wrong on my end.

[pbaldy]

Is the field text? If so try:

=Sum(IIf([Status]="1",1,0))

[BEstes]

That did the trick! Thank you so much!

[pbaldy]

Happy to help!