Hello All! I'm new to the forum and have a question about counting groups!
I have a report that has 1 group - Ticket #'s, this group also has a formula attached to it to suppress certain Ticket #'s.
I would like to be able to put the Total # of Tickets in the Report Header based on the Ticket #'s that are not suppressed.
For example:
1
12 (suppressed)
123
1234
12345(suppressed)
123456
1234567
I would expect to see 5 at the header level...
Any idea on how I can accomplish this? When I try to do a formulat to set a value to 1 or 0 based on my suppression formula and then do a sum of that formual it tells me I can't sum a summary...
Any help is greatly appreciated!
I have a report that has 1 group - Ticket #'s, this group also has a formula attached to it to suppress certain Ticket #'s.
I would like to be able to put the Total # of Tickets in the Report Header based on the Ticket #'s that are not suppressed.
For example:
1
12 (suppressed)
123
1234
12345(suppressed)
123456
1234567
I would expect to see 5 at the header level...
Any idea on how I can accomplish this? When I try to do a formulat to set a value to 1 or 0 based on my suppression formula and then do a sum of that formual it tells me I can't sum a summary...
Any help is greatly appreciated!