Formatting a number to Currency does not work

[ben]

Wappler Version : 6.0.0 Beta chanel
Operating System : Windows 11 pro
Server Model: NA
Database Type: SQLite
Hosting Type: Wappler Local Server

Actual behavior

When I select Inner Text and no formatting, the price shows as in

When I now format the number to Currency, the price disappears as in

[brad]

I’m not sure if this is your case or not but I find I always have to convert to number then to currency.

[ben]

Thank you Brad. I had not thought of doing that because it is stored as a number in the database.

I still think that this is a bug because of that, otherwise it could be a bug for Wappler to give me to the choice of choosing the currency format prior to converting to number. Very confusing!!!

[famousmag]

Hey @ben,

I also have to always use first .toNumber() before formatCurrency when I handle a Decimal value…

[Teodor]

But is your actual price value returned as a string or as a number, when you check the results in the dev tools > Network > XHR?

[ben]

It is a string as in 89.95

In that case Wappler should not allow me to choose to choose Numeric.

[famousmag]

Wappler return DECIMAL as TEXT

The decimal values do not fit the JavaScript number type so it becomes a string. You need to convert them to number if you want to apply numeric formatters to them or do any calculations.