Posted By: Andrewarbogast — 31 Aug 2017 at 8:50am
I'm working with 5 columns (ID, caseworker, service code, Date of service, and Years Since Service)
I suppressed
So I suppressed Date of Service using {@Years Since MHA}<=3
Now I'm trying to total the amount of clients left.
Please help.
Posted By: DBlank — 31 Aug 2017 at 9:01am
use a running total with the an evaluate formula that is the opposite as your suppression formula
Posted By: Andrewarbogast — 1 Sep 2017 at 4:13am
The formula gave me a total but it's not correct. I exported it into excel and the crystal total was off by about 900.
Any idea?
Thanks
Posted By: DBlank — 1 Sep 2017 at 4:42am
are you doing a distinct count