407-248-1481

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 5.5 Build 1
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