STACK.EXPANDUNITRANGE
Introduction
The STACK.EXPANDUNITRANGE function returns sorted names of units of measure within a given project matching the search criterion.
Syntax
CODE
=STACK.EXPANDUNITRANGE(ConnectionName, Project, UnitOfMeasure)Parameters
Parameter | Required/Optional | Description |
|---|---|---|
| Required | The name of the connection, as specified in the Connection Manager |
| Required | Project name. |
| Optional | A search expression for filtering units of measure, uses Velixo filtering techniques. If not specified, returns all units. |
Example
=STACK.EXPANDUNITRANGE("Stack", "Second Project")
Description: Returns all units of measure used in the Second Project project for the connection named Stack.
Result:
