STACK.TAKEOFFQUANTITY

Overview

The STACK.TAKEOFFQUANTITY function returns the number of units used in a all Takeoffs that match the filtering criteria within a given project.

CODE

=STACK.TAKEOFFQUANTITY(
    ConnectionName,
    Project,
    Takeoff,
    UnitOfMeasure,
    Plan,
    Tags,
    Labels
)

Argument	Required/Optional	Description
`ConnectionName`	Required	The name of the connection, as specified in the Connection Manager
`Project`	Required	Project name. Use the STACK.EXPANDPROJECTRANGE function to retrieve the list of Projects.
`Takeoff`	Required	A search expression for filtering Takeoff values, uses Velixo filtering techniques. Use the STACK.EXPANDTAKEOFFRANGE function to retrieve the list of Takeoffs.
`UnitOfMeasure`	Optional	A search expression for filtering Unit values, uses Velixo filtering techniques. Use the STACK.EXPANDUNITRANGE function to retrieve the list of Units of Measure.
`Plan`	Optional	A search expression for filtering Plan values, uses Velixo filtering techniques. Use the STACK.EXPANDPLANRANGE function to retrieve the list of Plans.
`Tags`	Optional	A search expression for filtering Tag values, uses Velixo filtering techniques. Use the STACK.EXPANDTAGRANGE function to retrieve the list of Tags.
`Labels`	Optional	A search expression for filtering Tag values, uses Velixo filtering techniques. Use the STACK.EXPANDLABELRANGE function to retrieve the list of Labels.