Sum of two selected rows in a table with multiple rows

Hi , My intercompany receivable account include other receivables amount and I have been trying to Update the total to reflect the correct amount after mapping it. Is there a formula or tool I can use to add up accounts balances for BS62000200 and BS62005000 and replace YTD column with correct total ($394)? Will I be able to remove "Other receivables" row after I merge it with Intercompany receivables?

Thank you!

Help

Accepted answers

AngelosPachis

Hi @mmmaryna ,

That's an interesting question, a simple way would be to add an additional column where you have to define the sign and the workflow should be slightly different.

Then in the formula tool, I have included an IF statement to check for the sign you have inputted in the lookup table. It should get the job done.

Hope that helps,

Angelos

example.yxmd

All comments

Emil_Kos

Hi,

Do you have any logic which will be used to identify which accounts should be merged?

There will be more positions that this logic should be applied too?

mmmaryna

Unfortunately, no logic is used for this. I just need to merge these two accounts in one balance based on how we want to present it in our analytics.

The other positions will be similar case but deducted from each other.

Thank you!

AngelosPachis

Hi @mmmaryna ,

I've used a lookup table and worked my way into bringing the table to the desired format since there is no particular logic.

I've summed Intercompany with Other receivables and then filtered out the latter.

Regards,

Angelos

example.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703