Neo_X,
Most of the folks who answer questions here are in the US. ALL of us are volunteers who answer questions when we have time. Like any other all-volunteer forum, you cannot expect immediate answers.
Here's what I would try. Change your formula to something like this (use the correct field name....)
if left (totext({ACTIVITYM1.DESCRIPTION}),35) = "Incident Status Change to Completed" then {ACTIVITYM1.INCIDENT_ID}
Then, instead of doing a sum, do a distinct count on the Incident_ID to get the number you're looking for.
-Dell
Edited by hilfy - 17 Oct 2012 at 6:39am
IP Logged
