Quantity function

This function returns a result based on the value of the Quantity cell (Enter Dimensions window and variable pane of takeoff windows) used to calculate takeoff quantities.

Syntax

QUANTITY

Example:  

IF (QUANTITY LE 10, Ton-Rebar, 0)
This executes the Ton-Rebar formula if the quantity is less than or equal to 10. Otherwise, the function returns a zero.

Caution!  

  • When calculating the takeoff quantity, Sage Estimating (SQL) multiplies the value of the Quantity cell by the results of the formula. To keep from squaring the takeoff quantity, be extremely cautious about using the QUANTITY function within a formula.
  • Using the QUANTITY function to calculate the quantity of assembly items may cause unexpected results when you replace a pass in assembly takeoff.