Accounts aggregation issue

[DebjitSingha]

Hello everyone,

I have the following Account hierarchy (simplified):

+ Gross Profit

- Net Sales (INC)

- COGS (EXP)

- COGS per Kgr (NFIN)

The issue is that SAC does not calculate the parent member Gross Profit when COGS per Kgr is below Gross Profit unless I move it under a different parent but then I can't display the info according to requirements, which is COGS per Kgr just below COGS on the same table.

Any ideas?

Thank you!

P.S This is my first post 🙂

[DebjitSingha]

welcome to community 🙂
Can you share screenshot of your account dimension setup.

Thanks,

Debjit

[William_Yu1]

Hi k_hatzikos50，

Have you simply tried creae an account formula on ‘Gross profit' to just sum Net sales and COGS?

Best regards, William

[k_hatzikos50]

No, I don't want to add or subtract "Gross per Kgr" with "Net Sales" and "COGS" as it would make no sense, I just want to ignore it. But I need it there, in that hierarchy tree below "Gross Profit".

[DebjitSingha]

Got it. Formula parent node then.

Thanks,

Debjit

Note: comments can be used for reply. Keeps the thread clean for others.
🙂