Formating numeric fields

[TonyS]

I want the data that is stored in my database as float type to show as a float in the label that's mapped to it. Is this possible?

[TonyS]

Sorry I sorted it.

var tprice = value.parseFloat();
return tprice;

in the mapping:)

[TonyS]

Just an update anyone know why toFixed wont add trailing zeros?

so numbers show as 365.50 and not just 365.5

[Illya Stepanov]

Hi Tony -

You can pass the number of digits to appear after the decimal point into this method: code.toFixed([digits])/code

More info you can find here: https://developer.mozilla.org/en-US/d...

[TonyS]

Yeah I know but this doesn't work...

var tprice = value.parseFloat().toFixed(2);
return tprice;

[TonyS]

is it the parseFloat?

[TonyS]

Yep; it was the parseFloat:)