Accounts aggregation issue

[k_hatzikos50]

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

[DebjitSingha · Accepted solution]

Hello k_hatzikos50.

There are multiple ways to get around this restriction of "aggregation on formula node".

One way would to use formula at parent level, instead of relying on "Account Type" and letting SAC decide how it will treat individual node for aggregation. This process will give you mode control as well. Here is an example-

In below example "Test Gross + Ind Exp" is simile addition of top nodes. Which is working as expected. Tough as I added it under "Operating Income", aggregating is not working. This due to the inclusion of formal that do not support aggregation.

Now what we can do is change Operating Income node to formula node.

Before:

After:

Formula at parent node now working:

Another simple fix would be to update currency and unit column: (PL650 is calculated node)

Before:

After:

Now your report will consider this node based on account type selected. In your case Gross Profit will consider COGS per Kgr (NFIN) as well.

Hope this helps. Let us know if you have any query around this topic.

Viewers/ readers - If you find above information helpful, feel free to up-vote (arrows on left side).

Thanks,

Debjit