How can I show percentage of total on report?
Posted: Fri Aug 08, 2008 1:00 pm
I have a report that displays Incident number and a "Closed on 1st Call" boolean value.
I would like to show a total at the bottom that looks something like this:
TOTAL COUNT: 147
Closed on 1st call: 65%
Not closed on 1st call: 35%
How can I do this?
I tried this, but I get syntax errors:
Closed on 1st call: {Div(Sum(IIF(Incident.Closed_on_1st_Call,1,0)),Count())*100}%
Not closed on 1st call: {Div(Sum(IIF(Incident.Closed_on_1st_Call,0,1)),Count())*100}%
If I replace Count() with a number (100) it works:
Closed on 1st call: {Div(Sum(IIF(Incident.Closed_on_1st_Call,1,0)),100)*100}%
Not closed on 1st call: {Div(Sum(IIF(Incident.Closed_on_1st_Call,0,1)),100)*100}%
Thanks!
I would like to show a total at the bottom that looks something like this:
TOTAL COUNT: 147
Closed on 1st call: 65%
Not closed on 1st call: 35%
How can I do this?
I tried this, but I get syntax errors:
Closed on 1st call: {Div(Sum(IIF(Incident.Closed_on_1st_Call,1,0)),Count())*100}%
Not closed on 1st call: {Div(Sum(IIF(Incident.Closed_on_1st_Call,0,1)),Count())*100}%
If I replace Count() with a number (100) it works:
Closed on 1st call: {Div(Sum(IIF(Incident.Closed_on_1st_Call,1,0)),100)*100}%
Not closed on 1st call: {Div(Sum(IIF(Incident.Closed_on_1st_Call,0,1)),100)*100}%
Thanks!