Hello,
I have a report that shows the serial numbers of cameras by location for our company. At the end of the report I do a count expression:
=Count([Camera Serial #])
This counts all the cameras in the report. My problem is that the report also lists dead cameras. I want to still be able to list the dead cameras under their location: Written Off/Dead ... but I want the count to exclude that locations cameras from the count. Is this possible? Thanks for your help...
Blake