Datatype recommendation for currency the retool database


I was planning on using NUMERIC(10, 2) but has seen people with issues sorting or manipulating the data.

Any recommendations or things to keep in mind?

Hi @Shawn_Optipath Using type number with 2 decimal places in your Retool DB should work:

In your app you can then set up your table column to format currency and can select which currency you'd like to use

Ok, thanks for confirming!