STACK.ESTIMATEWORKSHEETOTHERCOSTS
Created by Velixo Team, Modified on Fri, 29 Aug at 8:35 AM by Velixo Team
Applies to
Velixo NX 2025.8 or higher
STACK
Introduction
The STACK.ESTIMATEWORKSHEETOTHERCOSTS function returns Other Costs lines in a given Estimate Worksheet.
Syntax
=STACK.ESTIMATEWORKSHEETOTHERCOSTS(ConnectionName, Estimate, Select, OtherCostType, TableOutputCell)
Parameters
Parameter | Required/Optional | Description |
|---|---|---|
ConnectionName | Required | The name of the connection, as specified in the Connection Manager |
Estimate | Required | Estimate name. |
Select | Optional | A comma-separated list of case-insensitive field names to be included in the results as columns. Run this function with this argument omitted to see all available fields. |
OtherCostType | Optional | An optional filter by cost types. Available values: D - Direct Costs, I - Indirect Costs, C - Contingencies, O - Overhead, P - Profit, T - Tax, and their combinations. For example: DIT |
TableOutputCell | Optional | If the parameter 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 parameter is omitted, the result is returned as an array. |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article