SAP SAC Cell reference issue with Hierarchy

[v_sridhar9]

Dear Experts,

I am having an issue in a SAC import connection report which has a G/L Hierarchy. I have created some calculations in the report using the cell reference like total assets = Current assets + Property + Long term assets (A5+A13+A25) but when I collapse the Assets node it leads to 0.00

alue and cell reference shows REF_ERROR. Please suggest me how we can fix this. Please check the screenshots for your reference.

Thanks

SV

before collapse

After collapsing the node

[N1kh1l · Accepted solution]

v.sridhar9

This is the expected behaviour. Cell level formula only work good with static references and visible cells. If the table column/rows are not static or cell is not visible, you will get reference errors. As an Alternative, you can adjust you GL Hierarchy to create the Total Assets Node or also create a calculated Account in the Account dimension and put the formula there.

Hope this helps !!

Br.

Nikhil

[v_sridhar9 · Accepted solution]

Creating a account dimension is the best approach it seems. Thanks