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

Print Layouts - Formula - Display Discount Percentage for Discount Line

This information applies to :

Article ID
6694

Created/Updated
December 12, 2014

Category

Are you using the most current release of QuoteWerks?
Version 24.0 Build 2
Question:

How can I display the discount percentage for a discount line item in a footer section?

Answer:

Add a formula field (Insert->Formula Field from within the Layout Designer) and enter in the following formula:

.if.documentitems->linetype=64.then.documentitems->extendedprice/(documentheaders->subtotal-documentitems->extendedprice)*100*(-1)

Once you have added the footer, you'll want to double click on the field to change the formatting. Add decimal places if you need decimal places, put the % symbol in the Currency Symbol box and check "Currency Symbol After Amount", and last make sure that the Summarization Type says Value, not Total.

This should now display the discount percentage in the footer.

New Search

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