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

Print Layouts - Calculations on summed Detail Section values

This information applies to :

Article ID
6357

Created/Updated
November 2, 2006

Category

Are you using the most current release of QuoteWerks?
Version 24.0 Build 2
Question:
I have two values that I am totalling separatly and would like to perform a calculation on them AFTER they've been Totalled.

Ex: I want to add up the CustomNumber01 values of all of the line items then add up the CustomNumber02 values of all of the line items and then divide the summed CustomNumber01 by the summed CustomNumber02.


Answer:
Add a formula to your report footer and paste in the following formula:

.total-of.documentitems->customnumber01/.total-of.documentitems->customnumber02

This first totals (sums) the custom number values and then performs the calculation (in this case division).


Print Layouts - Calculations on summed Detail Section values

New Search

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