SUM function requires a list of numeric inputs

I get this error when trying to get the sum of a list of decimal numbers

Here is my table:

And here is the full formula for Upper Category LIst:

SELECT(Data[Amount], AND(
([Upper Category] = [_THISROW].[UpperCategory]),
([TransactionType] = [_THISROW].[TransactionDrop])

I’ve already tried using SUM(LIST([Upper Category List]) but it’s still not working. Does anyone have an idea how I can move forward with this?

Could you please ensure the element type of column [Upper Category List] , is “Price” or such numeric type column such as number or decimal. Is it currently set as Text type of something similar?


Hi Suvritt! That definitely solved the problem! Thank you so much!