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?

0 3 1,133
3 REPLIES 3
Top Labels in this Space