Limit number of decimal on load

[#1]

How would I limit number of decimal to only 2 in the load statement?

My numbers come with different number of decimals.

E.g.

if it's a whole number -  259.00000 (number of zeros vary) - I want this to be 259

if it's not  - 485.9994 , 323.25, 101.444 - I want this to be 485.99, 323.25, 101.44

[sunny_talwar · Accepted solution]

May be using Num() function

Num(NumberField, '#,##0.00') as NumberField

[#3]

Will this make 259.00 or 259? I would need the latter.

[surendraj]

Hi,

you can also try it in front end.

properties-->number tab-->

you can override as you can...

--surendra

[#5]

Thanks Surendra. I am aware of this option. However, I need it to be on LOAD

[sunny_talwar]

259.00