When I write a report to give back count of new incidents in a month - the figures are not correct as it will count any call which has an unresolve as another incident even though the im_id is the same. I am using pm_process.pm_creation_date as my count mechanism but how do I get it to only count record once?
This content has been marked as final. Show 2 replies
Better to do your count on the pm_id, and make sure its a Count rather than a Distinct Count
I have got the answer need to use a line in formula of
this way it does not count any subsequent entries