Sum Price of another table with enumlist

[G_S]

I am having a table Order with the column product and total price
I am having product column as Enumlist with ref -Product table
Total Price column with data type Price
I am using expression
ANY(SELECT(Product[Price], IN([ID],[_THISROW].[Product ID])))
Its resulting only the price of one product which I select in Product Column
I need the sum of the price which I select multiple Products in the Product Column -enum list

[Steve]

help.appsheet.com

SUM()

Arithmetic sum of list items

[Uk]

Maybe like this

SUM(SELECT(Product[Price], IN([ID],[_THISROW].[Product ID])))