407-248-1481
QuoteWerks Logo - QuoteWerks Sales Quoting and Proposal Software - CPQ that integrates with leading CRM, PSA, and Accounting Solutions (ConnectWise, Autotask, QuickBooks, salesforce.com and more)
Start Free Trial
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 2
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)