QuoteWerks Knowledgebase Topic (Article ID 5460)
Print Layouts - Totaling a DocumenItems CustomText field
This information applies to :
April 27, 2004
How do I utilize a customtext field and perform a calculation on this field?
1. In the print layout designer create a new formula field called "RecurringCharge".
2. In this formula field insert the function ToNumber() to convert the the
text to a number and use it as follows:
Assuming that your recurring charge is being stored in the CustomText01 column of the Document Items tab.
3. Insert the formula field in the Detail Section 1 of the print layout.
To total all these values for the line items, select the formula field, right click, and choose copy. Select the Report Footer 1 section, right click and choose paste, and then position this copied field somewhere in that section. Select this copied field, right click and then choose Format. For the summarization type setting choose TOTAL.
©1993-2020 Aspire Technologies, Inc.
407-248-1481 (9am-5pm ET M-F)