Showing mulitple zero in Summarize tool

[Srawat]

Hi,

I am using summarize tool to adding to transaction both are same value dr. and cr. and will be zero. however the zero result coming in mulitple zero. Please advise how can we reduce the zero with one digit.

Thanks,

[DataNath]

@Srawat will this value always be 0? Or can it be other values and you only want it to be '0' when the result is zero? If it's always going to be zero then you could just use a Select tool and make the field a byte:

Before:

After:

[RogerS]

Use a select tool after your output and change the type to fix decimal and adjust the size.  The size is the larges number of places before and including the  '.'  and decimal places.  The number after the  decimal represents total number of decimal places.  For example if your number is gong be no large than 999.9 with one decimal your size will be  5.1

[gautiergodard]

Hi @Srawat 

What is the data type of this field? If it's a string, you could use the select tool and convert the data type to a double or a byte.

Alternatively, you could use a formula in a formula tool to perform the rounding:

round(tonumber([number]),1)