Tuesday, February 12, 2013 10:29 PM
i have a report where i need to calculate % based on a condition.
column1= Resolution Time
Column2=total number of Incidents
i calculated number of incidents by using count(incidents)
now i need to calculate a percentage of number of incidents closed where the resolution time is 0
(Tickets closed where Resolution Time=0)/Total Number of Tickets *100 which would give me
% of calls with 0 resolution time.
I am having trouble with expression ??
Wednesday, February 13, 2013 2:46 AM
Hello, your expression should be something like
=iif(Fields!ResolutionTime.Value = 0, Count(Fields!Incidents.Value)/Count(Fields!Incidents.Value, "YourDatasetName"), 0)
If you could be more specific pls do it.
Regards | John Bocachica | MVP www.sqlgeek.net
Thursday, February 14, 2013 9:52 PMThanks ..i got it