Grouping Formula

[rbh123456789]

CR 11.5

I am trying to accomplish something that is easy in theory, but is proving to be very difficult.

- i have a group
- that group is grouped by individual
- inside that group i have a summary COUNT to calculate how many Cases each person is assigned to

What i want to know is 'of those individually assigned cases, what PERCENTAGE of them are CLOSED.
(i have a field in the report that has the value for each case, 1=open 2=closed)

Please help!!

 

[lbass]

//{@closed}:
If {table.status} = 2 then 1

Then your percentage becomes:

sum({@closed},{table.person}) % count({table.case},{table.person})

Be sure to use sum, not count, for number closed.

-LB

 

[rbh123456789]

THANK YOU LBASS!!!!