407-248-1481
QuoteWerks Turkey Logo - QuoteWerks Sales Quoting and Proposal Software - CPQ that integrates with leading CRM, PSA, and Accounting Solutions (ConnectWise, Autotask, QuickBooks, salesforce.com and more)
Request a Demo
Customer Area

QuoteWerks Knowledgebase Topic (Article ID 6192)

The Custom Number Field is Truncated after 15 Characters

This information applies to :

Article ID
6192

Created/Updated
January 4, 2006

Category
Custom Fields

Are you using the most current release of QuoteWerks?
Version 24.0 Build 4
Issue:
When entering a long number into a custom number field such as 1234567890123456, the custom number field changes to 1.23456789012346E+15.

After the 16th digit is entered, the number changes to a truncated scientific notation value.

Cause:
The QuoteWerks Custom Number Field is a Double. To quote a Microsoft article: "a Double value contains 15 decimal digits of precision" - http://msdn2.microsoft.com/en-us/library/system.double.aspx

Solution:
Try using a Custom Text Field. If you need to perform numeric operations on the number, you can use the toNumber function in your formula.

New Search

  •            
©1993-2024 Aspire Technologies, Inc.
    407-248-1481 (9am-5pm ET M-F)