1 Reply Latest reply on Aug 28, 2016 7:31 AM by Yuriy Fal

    Percentage between opposite elements in a table

    Andrea Clerico

      Hello,

       

      I am trying to calculate the percentage between elements with opposite indices.

       

      If we see the table as a matrix, I would like to calculate the % between elements in position (a, b) and (b,a).

       

       

      For instance, the diagonal would be all 50 %, the element (2,1) would be (341 * 100) / (341 + 1005) = 25 % and the element (1,2) will be 75 %.

       

      Do you know how I can reach this result?

       

      Thank you in advance for your help

       

      Andrea