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
That also returns a 0. Any other way I can get the percentage of this?
error
System.Web.Services.Protocols.SoapException: The Value expression for the textrun ‘Textbox13.Paragraphs[0].TextRuns[0]’ contains an error: [BC30198] ')' expected.
also strange that this returns all tickets and not just a count of awaiting information?
got around this by adding the expression to a table instead of a text box with this =sum(IIF(Fields!STATUS_NAME.Value = "Awaiting information",1,0)/count(Fields!id.Value))
strange where there should be a dot I have a comma like this 51,25% even after formatting, can this be changed??
Avg expression
Posted - 12/11/2012 : 08:41:26
