11 Replies Latest reply: Oct 18, 2011 11:02 AM by Stefan Wühl RSS

    Product of all Percentage of all rows in a table-diagram

    Martin Vierling

      Hi,

      I have a nice problem:

      There is a table (diagram) containing a number of rows, a dimension and a percentage:

      AccountPercentage
      A50%
      B30%
      C60%

       

      What I want to see, is the product of all percentages (50% x 30% x 60% -> 0.5 x 0.3 x 0.6 -> 0.09 -> 9%) as a column:

       

      AccountPercentage
      A9%
      B9%
      C9%

       

      How can I achieve this?

       

      Thanks a lot in advance,

      Martin