2 Replies Latest reply on Oct 30, 2012 11:40 AM by Julia Hennelly

# percent table calculations advanced how do they work?

I am using an advanced table percent calculation and it is not working quite as I would expect.  I am looking at a baseline test with a result of acceptable or unacceptable.  I would like to see the percent of employees that are acceptable, % unacceptable by hospital for the quarter when they took the test.  In the chart below each colored line is for a hospital.  The calculation is an advanced to the level of hospital.It is almost there but not quite and I am wondering what I am missing?  Numbers for each column should add to 100%.

Ideas?

• ###### 1. Re: percent table calculations advanced how do they work?

Assuming that you want to look for ratio of Acceptable vs Unacceptable within each hospital, i.e. same colour points in each column add to 100%, then you don't need to use Advanced partitioning, just Compute using -> Acceptable (see attached workbook, second sheet).

Is there a reason you attempted the Advanced option?

• ###### 2. Re: percent table calculations advanced how do they work?

That is exactly what I needed - thank you.  I guess I was making it WAY too complicated.  Thanks for your response.

Julia