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

Print Layouts - Formulas - Whole Number Tax Rate

This information applies to :

Article ID
5447

Created/Updated
January 16, 2009

Category
Print Layouts

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

How do I get the Tax Rate to display on the layout as a whole number with the percentage symbol following? Using the Data Field "LocalTaxRate" isn't working.


Answer:

What you can do is create a formula field that multiplies the LocalTaxRate * 100 and display that formula field instead.


Create a new formula field by selecting Insert | Formula field. Give it a name without spaces or punctuation, "FormattedTaxRate" for example. Then in the window that displays next, use this formula:


DocumentHeaders->LocalTaxRate*100


and place the field in the print layout. Once in the layout, double click on the field, set the summarization type to VALUE, set the decimal places to 2, add the % symbol for the Currency Symbol and check the box for "Currency Symbol After Amount". That should now display the rate as a whole number and include the % symbol after the value.

New Search

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