Our database follows a convention of storing currency amounts using the smallest denomination... so US $10.00 is stored as 1000. We are configuring Metabase model fields to multiply by 0.01, but we have a lot of fields and need to remember to do this for each new field added in the future. it would be nice if this could be configured as the default behavior for the Currency data type. Thanks.
I would recommend defining this in the Admin > Data Model > (db) > (table) > (field) > Formatting, so it's defined for the column in general.
Thanks for the response @flamber . I'm aware of this option but as I mentioned, we have many columns that would need to be formatted. The feature request is to be able to globally configure the Currency type with a multiplier. Thanks.