Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
How many decimal places can be held in a "Number" field in a User-Defined Table? — Cloud Customer Connect
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
13
Views
4
Comments
in Payroll and Global Payroll Interface (GPI) 4 comments

Summary:

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):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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