STACK.ITEMCOSTREPORT

Overview

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

CODE

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

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
`CostType`	Optional	A search expression for filtering cost types, uses Velixo filtering techniques. If not specified, returns all cost types.
`TakeOff`	Optional	A search expression for filtering takeoffs, uses Velixo filtering techniques. If not specified, returns all takeoffs.
`Plan`	Optional	A search expression for filtering plans, uses Velixo filtering techniques. If not specified, returns all plans.
`Item`	Optional	A search expression for filtering items, uses Velixo filtering techniques. If not specified, returns all items.
`Tag`	Optional	A search expression for filtering tags, uses Velixo filtering techniques. If not specified, returns all tags.
`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.

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: