PaulPeterson1
5 years agoQrew Assistant Captain
Data loss when sorting
I have a text field containing a 13 digit number (saved as text). When I customize the report to group or sort on this number some of the fields are converted to scientific notation. The source data is coming from an external database and is coming in as a text field.
What can I do to preserve all of the numbers in the field?
PS. it seems odd to me that some records retain all of the digits while others are truncated into scientific notation.
------------------------------
Paul Peterson
------------------------------
What can I do to preserve all of the numbers in the field?
PS. it seems odd to me that some records retain all of the digits while others are truncated into scientific notation.
------------------------------
Paul Peterson
------------------------------