Removing decimals orconverting values in 2 decimals

[deepa_bharadia]

hi,

is there any way we can convert numeric values in 2 decimals or remove decimals?

[Deano478]

can you give us some sample data to test on

[Deano478]

@deepa_bharadia to get a value to 2 decimal places you can change the data type to fixed decimal in the select tool to and set it to 19.2 or 11.2 depending on the size of the figures you have 

[deepa_bharadia]

hi thank you for your reply.

I am trying to change the size to 2 as below, but the filed is grey and i am unable to change it .

please refer to the email attached.

unable to change the size

[Deano478 · Accepted solution]

So are you able to use the drop down feature for the datatype? because for 2 decimal places you want to use fixed decimal not double 

[caltang]

Use a multi-field tool - it'll let you change the data type and size accordingly. 

If you need help, provide sample data.

[deepa_bharadia]

thanks for this, i have to use fixed decimal instead of double and then change the size.

[Deano478]

@deepa_bharadia no problem happy to be of help