Estimating Cost Database - Formulas Overview

Formulas are user-defined equations constructed using variables and are used to calculate an estimate line item's quantity. They can also be referenced in a Work Item and when added to the estimate the equation and variables will be copied along with the item's cost information. Thus, it is crucial that the unit of measure for the Estimate Line Item and Formula's calculated result are the same.

Example Formula

Important Things To Know

• Variable Codes should not have any spacing. Example 'L S' for Length of Slab.
• Variable Codes should not be a single character. Example W or L.
• If a multiplier is used in a Formula and is less than 1 (eg. 0.33), it must be preceded with a zero (0).
  
  Correct Equation = Length * 0.33
  Incorrect Equation = Length * .33

Formula Functions

• Add Formula
• Edit Formula

See Also

• Allowed Math Functions