I am running into an issue when I upgrade my number input to currency inputs.I have found that upgrading amount cents-based component fields/inputs into Retool’s newer Currency format requires us to convert our cents integer into a double-precision floating-point format based decimal. Has anyone found a simple way to update the display amount so it displays the amount cents divided by 100?
Details:
Screenshots:
App json export: (here's how to get a json export)
Hello @R_pm!
That is an interesting issue, you shouldn't need to convert to such a complex value data type 
At most it should only need a simple transformer to modify the data type or we can make a feature request to have to auto format the data type(as i had assumed the table would by default auto-convert).
Could you share a screen shot of the data values, table and the error you are getting?
To clarify, you have an amount value in cents like 2,001 cents that should be converting to a currency value like $20.01 but the error wants a "double-precision floating-point format based decimal"?