Number card *SUM* returning strange result

Hi,

I’m trying to create a management dashboard and I’m running into some issues.

I’ve got a report that generates the data seen below from a query:

I want to turn the sum of the second column into a card. I’ve configured the card as below:

When I add this card to the dashboard, It renders as below:

image

Any suggestions on how to fix this or what I’m doing wrong would be greatly appreciated.

Cheers,
Shaun.

Found a workaround for this - probably a better approach to start with. I made the report Standard, and switched to a script style report instead of a query. Making the report standard lets me work with the code directly in VSCode too, which is much better. The card loads correctly now.

image