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.

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

Argument	Required/Optional	Description
`ConnectionName`	Optional	Provide one of the following values: Connection name as defined in Connection Manager. Velixo range expression defining a set of connection names. An array of settings as described in the Multiple connections per formula article. We recommend using the VX.SETTINGS function to construct the array. OR Omit the argument to return results for all compatible connections with default aggregation settings.
`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.