3 Replies Latest reply on Oct 5, 2018 7:06 AM by Zhouyi Zhang

    Calculating percentage between two values depending on column value.

    James Carpenter

      I'm having difficulty calculating the "response rate" between two values, see below.

       

      Screen Shot 10-05-18 at 09.00 AM.PNG

       

      For example, I need to calculate the response for "CGM" for period "Q1". i.e. 2,994 / 363, 654

      Similarly, I need the same for all Quarters and Departments.

       

      Any thoughts?

       

      Thanks!