How to change size limit of Double or Int32?

[JJJJC]

I have some columns that are numbers. And I need the size limit to be more than 8. I cannot seem to edit the size in Formula or Select tool. How can I achieve this?

[ConnorK · Accepted solution]

Hi @JJJJC ,

In this situation I would try using a fixed decimal data type instead, as you can specify the amount of decimal points with this format. Below is a link to the range of values each numeric data type can accommodate for.

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

Best,

[PhilipMannering]

More than 8 what? The 8 here refers to bytes but can store up to 15 digits precision: https://help.alteryx.com/20213/designer/data-types

[PhilipMannering · Accepted solution]

From the same article, as @ConnorK mentions, is the fixed decimal where "maximum precision is 50, inclusive of the decimal point and negative sign (if applicable)."