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]

Hi Debjit, when Units & Currencies is set to Currency it substracts the "COGS per kgr" from "Gross Profit".

[DebjitSingha]

Great now at least parent node is considering this node. Change account type to INC from NFIN

Thanks,

Debjit