Change the data type from non-semantic type to quantity but not working

I got the error attached in screen- short.

Though, I have changed the data type from non-semantic type to quantity in data model but it can take sum of any field.

Please assist.

Attached Diagnostic INFO
{
"browser-info": {
"language": "en-GB",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.102 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.14.1+1",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.14.1",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.14.1+1",
"os.name": "Linux",
"os.version": "5.4.0-1066-aws",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"mongo",
"postgres",
"h2"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "12.8"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.2.23"
}
},
"run-mode": "prod",
"version": {
"date": "2022-04-07",
"tag": "v0.42.4",
"branch": "release-x.42.x",
"hash": "7c3ce2d"
},
"settings": {
"report-timezone": "Asia/Calcutta"
}
}
}

Hi @varnika
If your underlying database column type is a string, then you need to cast it to some numeric type.

you mean in data model tab in metabase itself OR in my database from backend?

@varnika I don't know any database which can do select sum(some_string_column)

but I have changed it into "Numeric" in data model. That's what I have mentioned.

@varnika Changing the field type (aka semantic type) in Metabase's Data Model will not change casting of the field.
You need to change casting on your database, or via SQL.

okay, thanks for help.