SI.EXPANDACCOUNTGROUPRANGE

Overview

The SI.EXPANDACCOUNTGROUPRANGE function returns the list of Name field values from the Account Groups form in Sage Intacct.

=SI.EXPANDACCOUNTGROUPRANGE(
    ConnectionName, 
    AccountGroup,
    AccountGroupType
)

The SI. EXPANDACCOUNTGROUPRANGE function uses the following arguments:

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.
`AccountGroup`	Optional	The range of account groups to include in the results. Supports Velixo filtering techniques. Account group names that contain characters with a special meaning in Velixo range expressions can't be matched with a standard range expression. These characters include `;`, `,`, `^`, `?`, `*`, a leading `-`, and the range delimiter. To match such names, use a regular expression instead. For details, see Filtering Velixo functions.
`AccountGroupType`	Optional	Filters the results by the type of members the account group contains, as set in Sage Intacct. Enter one or more of the following letters, in any order: `A` – accounts `C` – category `G` – groups `S` – statistical accounts `T` – statistical category `X` – computation The letters are not case-sensitive. Don't separate them with spaces, commas, or other characters. Default value: `ACGSTX` (all member types)

Assuming the following configuration within Sage Intacct:

=SI.EXPANDACCOUNTGROUPRANGE(
    "Sage"
)

Description: Returns the names of all account groups defined in Sage Intacct:

Result:

=SI.EXPANDACCOUNTGROUPRANGE(
    "Sage"
    ,
    "sx"
)

Description:

Result: Returns the names of account groups of types statistical accounts and computation defined in Sage Intacct.