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.
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.
I have done this and it rounds in both instances.
if you also have negative numbers, you need to use ceil instead of floor for negative numbers
if( FIELD<0, ceil(FIELD, 0.001), floor(FIELD, 0.001))
You can try with this
Hope it helps
Retrieving data ...