Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be using Num() function
Num(NumberField, '#,##0.00') as NumberField
May be using Num() function
Num(NumberField, '#,##0.00') as NumberField
Will this make 259.00 or 259? I would need the latter.
Hi,
you can also try it in front end.
properties-->number tab-->
you can override as you can...
--surendra
Thanks Surendra. I am aware of this option. However, I need it to be on LOAD
259.00