Hi.. In Database, we have a float value like "45.5", and in UI it has

you can use Text function to format output like below code.
text(10.25, "00.0")

Thanks for the reply!
I want to change 10.5 to 10.50
Tried multiple functions but no luck so far.

please try text(10.5, "00.00")

few questions
-> Is it multiple type or single type pv
-> what is data type of variable ( typename(typeof(pv!variable)))

Thanks! now it works with text(10.5,"0.00")

It is single type and in UI the data type is text but in database it is being stored as float.
however I am getting an abnormal behavior. The value of 9999999.99 is become 107 :)

try =fixed(999999.5,2).

It actually round off the number to most significant digits.

Please use text(ri!var, "0.00"). it work like this text(45.5, "0.00") -> 45.50 and text(37645, "0.00") -> 37645.00

why text(99999999999.99,"0.00") returns 21474836479.99 ?