Account Segment Syntax

For parameters that allow a single value, mask, range, value list, segment list, hierarchy value (parent group), or @ field, syntax examples are listed below:

Criteria Type	Syntax	Results
Single Value	`8000`	Retrieves value 8000.
Mask (wildcard)	`85` or `85` (see Note 1* below)	Retrieves values starting with 85.
Mask (wildcard)	`8` (see Note 1 below)	Retrieves values containing 8 in the second position.
Mask (wildcard) for All Values	`*`	Retrieves all values.
Mask (wildcard) for a Single Value	`8*00` or `8_00`	Retrieves values 8`x`00, where `x` is any character.
Range (see Note 2 below)	`8000.8599`	Retrieves values 8000 through 8599.
Blank Values (see Note 3 below)	`BLANK`	Retrieves all blank values.
Non-Blank Values (see Note 3 below)	`NOTBLANK`	Retrieves all non-blank values.

Click here to watch a video that walks you through this feature.

Note:

JD Edwards ledgers are case sensitive when specifying characters for a segment value.
SAP ledgers must use 85** syntax; one asterisk ( * ) for each digit or character being masked.

Note: The range delimiter may be defined in the user's Spreadsheet Server Settings

Note: BLANK and NOTBLANK values are only applicable to Infinium, JD Edwards, and SAP special ledgers.

Value List

A list of values may be entered for an account segment. This list may include single values, a range of values, a mask (wildcard) value, segment lists, hierarchy values, @ fields, or an excluded value (indicated by inserting a slash ( / ) before the value). Enclose the value list in square brackets ( [ ] ), and use the list separator defined in the Windows regional settings.

Criteria Type	Syntax	Results
Value List for a Single Value	`[8000,8250,8370]`	Retrieves values 8000, 8250, and 8370.
Value List for Range & Exclude Value	`[8000.8599,/8375]`	Retrieves values 8000 through 8599, excluding 8375.

Note: The range delimiter, list separator, and exclusions characters may be defined in the user's Spreadsheet Server Settings

Segment Lists and Hierarchy Values

Criteria Type	Syntax	Results
Segment List	`^CASH`	Retrieves all values in the `CASH` segment list.
Hierarchy Value	`^^1234`	Retrieves all values in group `1234`.

Note: SAP ledgers use a single caret ( ^ ) to identify SAP master data hierarchy sets, and a double caret ( ^^ ) to identify other SAP set names. If a master data hierarchy set and segment list are assigned the same name, the calculation uses the hierarchy set.

@ Fields

The syntax for an @ field is @aaa:bbb, where:

aaa is the alias or field name, as defined in Application Configurator.
bbb is the field value.

The specified field value may be a single value, mask, range, value list, or segment list. An @ field may be used alone or embedded in a bracketed value list.

Criteria Type	Syntax	Results
@ Field for a Single Value	`@myfield:2000`	Retrieves `myfield` value 2000.
@ Field using a Value List	`@myfield:[2000,3000]`	Retrieves `myfield` value 2000 and 3000.
@ Field in a Value List	`[100,@myfield:2000,600]`	Retrieves value 100 or 600, or `myfield` value 2000.

Note: If necessary, table qualifiers (syntax: @table.field:value) may be entered.

See Create or Maintain Segment Lists and Locate Segment for more information.

Account Segment Syntax

Value List

Segment Lists and Hierarchy Values

@ Fields

Related articles

Was this article helpful?