limiting the value by 2 decimals

[TonyMu]

Hello Guys, 

what is the best way to limit the value to 2 decimals? I usually choose "fixed decimals" in a formula but that option is not available for an existing column. 

for example I will change 2,34667 to 2,35

Cheers and thanks in advance

[atcodedog05 · Accepted solution]

Hi @TonyMu 

You can covert the existing column to fixed decimals using Select Tool. Fixed decimal 19.2 

.2 says round it to 2 decimals

Hope this helps🙂

[PhilipMannering]

Use the Select Tool and make the number Fixed Decimal XX.2. Probably the easiest way.

[Emil_Kos]

Hi @TonyMu,

I know my colleagues replied faster but please look into the article about the available data types:

https://help.alteryx.com/current/designer/data-types

Below you will have examples with different set ups of the select tool that are available:

The one that you should be interested in is: 

Good Luck!