I frequently run into type issues – I have a number coming back from the database, but as soon as I “format as…” so that I can get a thousands separator and rounding, bubble complains that it is text. What gives? This is from @Thimo 's excellent table/grid plugin.
When you use :formatted as… this modify the type to text and it’s no more a number.
Change the data type to be Text if you need to change the display in the table.
It’s does’t change anything. type will just display different options if you choose currency or percentge. Basically, it’s jsut how you want ot display the number.
Do your math operation first and after use format as to display it how you want it. It’s how format as work. Take a number and convert it to a string for display. In most case, format as will always be the last function to add to expression.
Alright – i’ll format it in the SQL query!