Sum(Select + _THISROW) Formula Problem

[Agny_Ferreira]

I’m working on an inventory app. I am using the formula below:
Sum(Select(Inventory[Amount], [ITEM ID]=[_THISROW].[Item ID]))
But the formula is summing the whole column [Amount] and not summing by [ID Item].

The total in-stock of all items is getting the same value.
Could you please help me?

[Aurelien · Accepted solution]

SUM([Related Inventorys][Amount])

For reference:

help.appsheet.com

SUM()

Arithmetic sum of list items

help.appsheet.com

List Dereference

Dereference the items of a list in bulk to produce a list of the resulting values.

[Agny_Ferreira]

Thank you!!! Thank you so much, I’ve been trying to solve the problem for days. Thank you so much, your formula worked!

[jyothis_m]

Are you applying this formula to a Virtual Column. If so please try saving your app and check if it shows correctly.

[Agny_Ferreira]

Yes, it is a virtual column. Even if I save the app, the formula keeps calculating wrong. Adding all the values ​​of the column [Amount] and assigning the same value to all the [Item ID].

[Aurelien]

Did you try that ?

Aurelien:

SUM([Related Inventorys][Amount])

[jyothis_m]

[ITEM ID] is your key column right? In that case you should be having only one row of each unique Item Id. There should not be same Item ID for more than 1 rows. To sum up if ITEM ID is the key column then there is nothing to sum() except that single row itself.

[Agny_Ferreira]

Got it, thanks a lot for the help! I managed to solve the problem. Thank you very much!!