407-248-1481

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