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

Print Layouts - Formula - Display % discount for line item.

This information applies to :

Article ID
5450

Created/Updated
May 31, 2005

Category
Print Layouts

Are you using the most current release of QuoteWerks?
Version 24.0 Build 2
Question
How do I display the percent discount for the line items?

Solution
Use the following formula field:

.if.first(documentitems->pricemodifier,1)="D".then.(last(documentitems->pricemodifier,(len(documentitems->pricemodifier)-1))+"%").else.""

OR

.if.(documentitems->unitlist)<>0.then.((documentitems->unitlist-documentitems->unitprice)/documentitems->unitlist)*100.else.0

New Search

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