1 Reply Latest reply: Oct 10, 2013 5:54 AM by Gysbert Wassenaar RSS

    P&L percentages

      Hello,

      I've built a P&L table using a Simple Table. The result is the one that follows:

      LevelAccount NameAmountPercentage
      100Revenue100.000100%
      200Cost of sales- 75.000- 75%
      300Gross Profit- 25.000- 25%

       

      I want to calculate the column "Percentage" but I don't know how to manage with it.

      I tried to use the following expression but it did't work: sum(Amount) / sum(total <Level> if(Level=100, Amount))

      Can somebody help me?

      Thanks in advance.

      Regards,