Datatype recommendation for currency the retool database

[Shawn_Optipath]

Hi,

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?

[Alice]

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

[Shawn_Optipath]

Ok, thanks for confirming!