Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a field that is 4 or more decimals, but I only want to show 3 decimals and I do not want to round.
Hi,
Do you mean in your script? Then use a number formatting function
Num(OriginalFieldName, '#,000') AS Fieldname
Or if you mean in a chart, go to the chart Properties, Number, and set it to fixed to three decimals.
Hope that helps.
Miguel
Hi,
You can try with this
Left(FieldName,Index(FieldName,'.')+3)
Hope it helps
Celambarasan
I have done this and it rounds in both instances.
Linda
then try
floor(12.345678, 0.001)
edit:
if you also have negative numbers, you need to use ceil instead of floor for negative numbers
ceil(-12.345678, 0.001)
if( FIELD<0, ceil(FIELD, 0.001), floor(FIELD, 0.001))