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 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 24.0 Build 2
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

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