Calculate percentage based on a condition in a report

Question

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 ??

---

HoneyBunch

Answer 1

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

---

Regards | John Bocachica | MVP www.sqlgeek.net

Answer 2

Thanks ..i got it

---

HoneyBunch