2 Replies Latest reply on Feb 11, 2013 8:09 PM by Kishore Rasuri

    % difference issue

    Kishore Rasuri

      Hi, I'm struggling to get this calculation right. In the attached workbook i'm doing the percentage different from previous visit for a particular subject. but there can be different raters for different visits and they are not aligned properly.

       

      pic01.PNG

      Like in the case above, the visits 7,8 are rated by different rater and the percentage difference between visit 6 and 7 is not right. Could you please suggest how to do it right.