Formula calculation

[Former Member]

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

[Former Member · Accepted solution]

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