SI.EXPANDCOSTTYPERANGE

Overview

The SI.EXPANDCOSTTYPERANGE returns an array containing one or more cost types configured within Sage Intacct.

Syntax

=SI.EXPANDCOSTTYPERANGE(
    ConnectionName,
    Project,
    Task,
    CostType,
    IncludeInactive,
    IncludeProjects,
    IncludeTasks
)

Arguments

The SI.EXPANDCOSTTYPERANGE 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.
`Project`	Required	The ID of the project (or multiple projects) for which Cost Types are to be shown (available in version 2023.10 and higher)
`Task`	Required	The ID of the task (or multiple tasks) for which Cost Types are to be shown (available in version 2023.10 and higher)
`CostType`	Optional	The range of cost types to include in the results. See our article on including multiple argument values
`IncludeInactive`	Optional	`TRUE` (default) or `FALSE` Determines whether or not to include entries with a Status field set to `Inactive` in the results.
`IncludeProjects`	Optional	`TRUE` or `FALSE` (default) Determines whether a separate column with project ID is included in the results (available in version 2023.10 and higher)
`IncludeTasks`	Optional	`TRUE` or `FALSE` (default) Determines whether a separate column with task ID is included in the results (available in version 2023.10 and higher)

Examples

Example 1 - all cost codes

=SI.EXPANDCOSTTYPERANGE(
    "Sage",
    "*",
    "*"
)

Description
Returns all cost types configured within Sage Intacct

Result

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/7pypsdvDgeMZARZsI-_JY1spuN_Cu_sb0w.png

Example 2 - active cost codes

Assuming the following configuration within Sage Intacct:

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/SvWOqk3bilY-mDbpd403zzTh62Lm1-JGGQ.png

=SI.EXPANDCOSTTYPERANGE(
    "Sage",
    "*",
    "*",
    ,
    FALSE
)

Description
Returns all ACTIVE cost types configured within Sage Intacct

Result

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/x3EaeT1WnRnKHVNWwCBuEhfXNE_u3g_Z7A.png

The inactive cost type BUR is not included

Example 3 - specific project and task

=SI.EXPANDCOSTTYPERANGE(
    "Sage",
    "20-001",
    "G01-040"
)

Description
Returns all cost types associated with task G01-040 in project 20-001

Result

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/lTpDhDNfGTVdFFwvzxcvrSMvmB2AHXgrTg.png

(cell references have been used for some arguments in this example)

Example 4 - including project IDs

=SI.EXPANDCOSTTYPERANGE(
    "Sage",
    "*",
    "*",
    FALSE,
    TRUE
)

Description
Returns all Project IDs and their corresponding active Cost Types

Result

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/n9QAjgSklT4IfC0dxjiOmGUnMxj7a6qloQ.png

Example 5 - including task codes

=SI.EXPANDCOSTTYPERANGE(
    "Sage",
    "TEST-2205",
    "*",
    FALSE,
    FALSE,
    TRUE
)

Description
Returns all Task Codes and corresponding active Cost Types for project TEST-2205.

Result

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/DPz4jQFxAMZsp6XjsDTneMc_vHN_E09dMg.png

If cost types have not been set up with Sage Intacct (or your user account does not have access to the cost type configuration), the function will return a #N/A error: