I'm trying to do a simple average in an expression: I want only to return the average percent of calls where STATUS_NAME = awaiting information, so the percentage of of all calls with awaiting information from the total calls. Here's what I have, I want to see the percent of waiting information against all calls...the below returns a 0??
Any help appreciated.
=Sum(IIF(Fields!STATUS_NAME.Value = "Awaiting Information",1,0),"OpenCalls_24_0")/Count(Fields!id.Value, "OpenCalls_24_0") help appreciated