STACK.ITEMCOSTREPORT

Overview

The STACK.ITEMCOSTREPORT function returns all Item Cost report records for a given project.

Syntax

CODE

=STACK.ITEMCOSTREPORT(
    ConnectionName,
    Project,
    Select,
    CostType,
    TakeOff,
    Plan,
    Item,
    Tags,
    Labels,
    TableOutputCell
)

Arguments

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 STACK projects.
`Select`	Optional	A comma-separated list of columns to be returned. Use column headers of the result table, for example, `TakeoffID` or `PlanName`. This argument supports aggregation functions.
`CostType`	Optional	A search expression for filtering cost types, uses Velixo filtering techniques. If not specified, returns all cost types. Use the STACK.EXPANDCOSTTYPERANGE function to retrieve the list of Takeoffs.
`TakeOff`	Optional	A search expression for filtering takeoffs, uses Velixo filtering techniques. If not specified, returns all takeoffs. Use the STACK.EXPANDTAKEOFFRANGE function to retrieve the list of Takeoffs.
`Plan`	Optional	A search expression for filtering plans, uses Velixo filtering techniques. If not specified, returns all plans. Use the STACK.EXPANDPLANRANGE function to retrieve the list of Takeoffs.
`Item`	Optional	A search expression for filtering items, uses Velixo filtering techniques. If not specified, returns all items.
`Tags`	Optional	A search expression for filtering tags, uses Velixo filtering techniques. If not specified, returns all tags. Use the STACK.EXPANDTAGRANGE function to retrieve the list of Tags.
`Labels`	Optional	A search expression for filtering labels, uses Velixo filtering techniques. If not specified, returns all labels. Use the STACK.EXPANDLABELRANGE function to retrieve the list of Labels.
`TableOutputCell`	Optional	If the argument is specified, the function output is represented as an Excel table, and the first column is populated at this address. See the Table Mirroring article for details. If the argument is omitted, the result is returned as a spill range.

Example

CODE

=STACK.ITEMCOSTREPORT(
    "Stack",
    "Second Project",
    A2
)

Description: Returns all Item Cost report records in the Second Project project for the connection named Stack.

Result: