407-248-1481

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 5.5 Build 1
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