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?
User | Count |
---|---|
19 | |
13 | |
8 | |
3 | |
2 |