407-248-1481

QuoteWerks Knowledgebase Topic (Article ID 5)

Print Layouts - Formula to display N/C or UnitPrice

This information applies to :

Article ID
5

Created/Updated
August 5, 2013

Category
Print Layouts


Are you using the most current release of QuoteWerks?
Version 5.5 Build 1
Question:
Whenever the unit price of a product is zero, I would like to have QuoteWerks display "N/C" for No Charge instead of zero. Can this be done?

Solution:
1. In the print layout designer, select the InsertFormula field menu. When the New Formula field window is displayed, enter a name for the formula field like FormattedUnitPrice.
2. In the formula editing window, type in the following formula:

.if. DocumentItems->LineType=1.and.DocumentItems->UnitPrice = 0.then. "N/C".else."$"+ToText(DocumentItems->UnitPrice,2)

New Search