Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
Create a variable vRevenue as =sum({<Level={100}>}Amount). Then use the variable in your expression: sum(Amount)/$(vRevenue)