Decimals Issue

Question

I need change the display of numbers to keep 2 decimals. The select tools seems only working for those number which has more than 1 decimal. e.g. 1.345 can be changed to 1.3 but 0 can not be changed to 0.00. Can I do this in Alteryx like I do in excel by changing the format?

Current ValueExpect ValueAlteryx Value00.0001.21.201.22.3342.332.3311.001

hellyars · Answer

@zqlcancer 
@binu_acs  is correct.

BUT >>> USE the Multi Field Tool to convert the field to a fixed decimal.

>>> To keep two decimal places change the default size from 19.6 to 19.2.

19.6 will generate 6 decimal places.    20 will become 20.000000

>>>19.2 will generate 2 decimal places.    20 will become 20.00

Technically 19.2 means 19 digits with 6 after the decimal

Raj · Answer

use select tool and set data type to fixed decimal and set 19.2

this suits best ib this case

ShankerV · Answer

Hi @zqlcancer

I could see the correct result when the same attached workflow by your's run in my system.

We are not sure what output you are seeing at your end.

If you are able to attach any screenshot of result you see will be easy to investigate further.

Many thanks

Shanker V