6 Replies Latest reply: Feb 13, 2017 5:37 AM by Sunny Talwar RSS

    Divide all values by one value from the table

    Mohammad Adnan Ansari

      I have a Profit And Loss statement table like below:

       

      PNL Head  - Amount

      Revenue - 500

      Cost of sales - 200

      Gross Profit - 300

      Other Expense - 100

      Net Income - 200

       

      I would like to show this table on the screen;  I would like to show a calculated column also which is the % age of PNL Head values with the total Revenue.

       

      The final table should look like below:

       

      PNL Head - Amount - %

      Revenue - 500 - 100

      Cost of Sales - 200 -  40

      Gross Profit - 300 - 60

      Other Expenses - 100 - 20

      Net Income - 200 - 40

       

      Pls let me know how to calculate the % column.