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

    percent table calculations advanced how do they work?

    Julia Hennelly

      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?

       

      Q Time Line Hospital.jpg