topic Re: Display decimals with no rounding in Water Cooler

Display decimals with no rounding

schoborg — Thu, 09 Feb 2012 14:33:21 GMT

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.

Miguel_Angel_Baeyens — Thu, 09 Feb 2012 14:43:54 GMT

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

CELAMBARASAN — Thu, 09 Feb 2012 15:01:06 GMT

Hi,

You can try with this

Left(FieldName,Index(FieldName,'.')+3)

Hope it helps

Celambarasan

schoborg — Thu, 09 Feb 2012 15:30:27 GMT

I have done this and it rounds in both instances.

Linda

swuehl — Thu, 09 Feb 2012 15:33:30 GMT

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))