How to change size limit of Double or Int32?
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Solved! Go to Solution.
- Labels:
- Developer
- Developer Tools
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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,
Senior Sales Engineer
Alteryx
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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)."
