Calculated SUM in SharePoint List Parent

[Lucas_Ignatius]

I've case about calculated in SharePoint List-2(TransactionBudgetMasterCategory)  will be update and SUM on SharePoint List-1 (BudgetMasterCategory).

Which SharePoint List-2 had connected column in SharePoint List-1 with Column type Lookup (IDBudgetCategory).

Problem how calculated sum in SharePoint List-1 column name "Realisasi" where is Column will be SUM from column name "Amount" from SharePoint List-2 (TransactionBudgetMasterCategory).

I give my picture SharePoint List, I hope my description can easy to understanding.

SharePoint List-1 (BudgetMasterCategory)

SharePoint List-2 (TransactionBudgetMasterCategory)

[CheckMate]

https://sharepoint.uservoice.com/forums/329214-sites-and-collaboration/suggestions/13981188-allow-lo...

workaround is to create a flow ...

1. when an item is created for List1

2. get item from list1

2. get item from list 2

3. update item in list2, id field enter the list where the item was created in(list1), and add sum amount field in list2(with fx)

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution.
If you have found my response helpful, please give it a thumbs up.

[Lucas_Ignatius]

Hi @CheckMate ,

Can you help about fx formula to sum?

[Lucas_Ignatius · Accepted solution]

I was success with this flow for SUM Calculated column in SharePoint List (SP List)

My flow

And this flow I break down for more detail

And flow will be sucessfull

This is my SPList,

I Hope this can help anybody with same problem with me

[CheckMate · Accepted solution]

@Lucas_Ignatius 

add(variables('number2'),variables('number1'))

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution.
If you have found my response helpful, please give it a thumbs up.

[Lucas_Ignatius]

Hai @CheckMate ,

If there is have 2 ID, is can possible to update based on ID? Because i tried will be update all ID on SharePoint List-1

SP List-1 , have 2 IDCategory but update all IDCategory

SP List-2 based on IDCategory