"Sum of" missing?


I'm trying to build a dashboard based on a few questions who, at the core, answer the following question:

"Show me all expenses for all domains(db)"

I start by pruning the database_names to have only the proper domains/databases.
This involve filtering with Salesforce as well as our amazon mysql instance.

I then join to this filtered list some expenses data which does have a $ field for amount.

But for some reason I can't see the sum of or cumulative sum in the options...

Why is that???

Thank you kindly,


What is the data type of the field at the DB level and also what type in Metabase data model?

1 Like

Apologies Luiggi, for the delay, and thank you for sharing. I started afresh and things worked out. thank you again!