Hello Experts,
In my report I have balance sheet hierarchy.
I have as follows:
Balance Sheet 0
Total assets 10
Total Liability -10
But I need the report as follows:
Variance
Balance sheet 24 100%
Total Assets 16 66.6%
Total Liability 8 33.3%
Since its a hierarchy how do I do this variance calculation.
Thanks in advance.
Sree
Hi Sree,
You can try this:
Create your Balanse Sheet as a text node, put Total assets and total liabilities as subnodes of this node.
In Bex add a calculated KF (formula), where use one of the percentage functions.
Best regards,
Eugene
Add a comment