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

    Percentage between opposite elements in a table

    Andrea Clerico



      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