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

Print Layouts - Formulas - Convert Text to Number

This information applies to :

Article ID
5451

Created/Updated
July 27, 2009

Category
Print Layouts

Are you using the most current release of QuoteWerks?
Version 24.0 Build 2
Question:
How do I convert text to a number for use in calculations?

Solution:
1. In the print layout designer, select the Insert-Formula field menu.
2. Enter a name for the formula field.
3. Insert the following formula:
tonumber(DocumentItems->CustomText01)

Notes:
The formula can be entered by:
1. Clicking on Function-Tonum
2. Data Field-Document Items Table-CustomText01

New Search

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