SI.EXPANDDEPARTMENTGROUPRANGE

Overview

Use the SI.EXPANDDEPARTMENTGROUPRANGE function to retrieve Department group range names.

=SI.EXPANDDEPARTMENTGROUPRANGE(
  Connection,
  Group,
  GroupType)

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.
`Group`	Optional	Filter by dimension group name. Supports Velixo ranges and wildcards. Example: `Hotels:Factories;-Shops`
`GroupType`	Optional	Filter by dimension group name, as defined in the `GROUPTYPE` Sage Intacct object. Accepted values: `specific-members`or `specific` - returns only static groups. `all-members`or `all` - returns only dynamic groups. Default value: all group members are returned

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.

Omit the argument to return results for all compatible connections with default aggregation settings.

Group

Optional

Filter by dimension group name. Supports Velixo ranges and wildcards.

Example: Hotels:Factories;-Shops

GroupType

Optional

Filter by dimension group name, as defined in the GROUPTYPE Sage Intacct object.

Accepted values:

Default value: all group members are returned