Page 1 of 1

How can I show percentage of total on report?

Posted: Fri Aug 08, 2008 1:00 pm
by Sandy Pham
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!

How can I show percentage of total on report?

Posted: Fri Aug 08, 2008 6:03 pm
by Vital
Hello Sandy,

Please try following expression:

Code: Select all

{Div(Totals.Sum(DataBand1, IIF(Incident.Closed_on_1st_Call,1,0)),Totals.Count(DataBand1))*100}%
Or you can one of latest prerelease build which contain fix for this problem.

Thank you.