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

Print Layouts - Formula - Multiple Qty * CustomText

This information applies to :

Article ID
5457

Created/Updated
April 20, 2004

Category
Print Layouts

Are you using the most current release of QuoteWerks?
Version 24.0 Build 2
Question:
How do I multiply the Qty * Custom Text field?

Solution:
1. Click Print-Select the layout-Click Edit
2. Select the Insert-Formula field menu.
3. Enter a name for the formula field like TotalManHours without spaces.
4. Insert the following formula:

tonumber(documentitems->customtext01)*documentitems->qtytotal

The Formula can be entered by following these steps:
1. Click on the Functions button, and choose the ToNumber()
2. Click Data Field, Select Document Items Table and CustomText01
3. Type * for multiplies
4. Click Data Field, Select Document Items Table and Select Qtytotal
5. Click on OK and place the formula field on the print layout in the Details 1 section.

New Search

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