P&L percentages

aleix_rodriguez — Thu, 10 Oct 2013 09:39:28 GMT

Hello,

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

Level	Account Name	Amount	Percentage
100	Revenue	100.000	100%
200	Cost of sales	- 75.000	- 75%
300	Gross 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,

Re: P&L percentages

Gysbert_Wassenaar — Thu, 10 Oct 2013 09:54:38 GMT

Create a variable vRevenue as =sum({<Level={100}>}Amount). Then use the variable in your expression: sum(Amount)/$(vRevenue)