harrietohs
IS-IT--Management
Using Crystal 8.5
I have a report that groups on a "status" field, and I show a total count for each status.
Example:
Status #
------ -------
Active 10
Held 3
Terminated 2
Instead of a grand total that adds the above numbers, I need to subtract the Held and Terminated from the Active, so the total on above the example would be 5. Any tips on how to most easily achieve this?
Harriet
Ottawa Humane Society
I have a report that groups on a "status" field, and I show a total count for each status.
Example:
Status #
------ -------
Active 10
Held 3
Terminated 2
Instead of a grand total that adds the above numbers, I need to subtract the Held and Terminated from the Active, so the total on above the example would be 5. Any tips on how to most easily achieve this?
Harriet
Ottawa Humane Society