You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How many decimal places can be held in a "Number" field in a User-Defined Table?

Accepted answer


User-Defined Tables can hold a "Number" value - how many decimal places can be held? Is there a minimum/maximum numeric value that can be held?

Content (required):

We have a requirement to hold the value 0.0199166666666667 in a UDT table (for example). This is 16 decimal places. Can that be held as a Number value, or should we hold it as a Text field and convert it to a number in a fast formula?

Also, sneaky second question, what are the min/max number sizes and decimal places limit for numbers within fast formula calculations?

Version (include the version you are using, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!