GXL Formula for Account Values

Use the GXL formula to retrieve account balances for a specific format or reporting period. Parameters in the GXL formula vary based on the selected ledger; basic processing is the same for all ledgers, however. Use the following as an overview of the GXL formula. Links are available at the bottom to access ledger-specific GXL information.

Syntax

=GXL("Key 1","Key 2","Key 3","Year","Format","Period","Account Segment 1","Account Segment 2","Account Segment 3","Account Segment 4","Account Segment 5"...)

Note: It is common practice to use cell references within GXL formulas to identify parameters.

Parameters

The following are general GXL formula parameters:

Key 1

This value varies based on the requirements of the selected ledger (for example, OracleKey 1 = Balance Type).

Key 2

This value varies based on the requirements of the selected ledger (for example, OracleKey 2 = Budget/En Type).

Key 3

The literals and values vary based on the requirements of the selected ledger. If more than one variable needs to be defined, separate the variables with a semi-colon ( ; ). If not being used, enter 0 or leave blank. For example, OracleKey 3 = Translated, Currency, Ledger (Book), and Summary Account.

Year

The year identifier.

Format

The basic valid formats are listed below, however, some ledgers may have other valid formats:

PER: Activity for a selected period, or range of periods.
QTR: Activity for the periods included in the selected quarter number.
DQTR: Activity for the periods included in the selected daily quarter number.
YTD: Activity for periods 1 through the designated period number, excluding the opening balance.
LTD: Activity for periods 1 through the designated period number, including the opening balance.
RANGE: Activity for a specified range of periods.

Period

Corresponds to a period, quarter number, or range of periods (for example, 1.5 for periods 1 through 5) for the specified format.

Account Segment 1-nn

Enter parameter for each segment of the account number. The number of account segments vary based on the account structure of the selected ledger. This may be a single value, mask, range, value list, segment list, hierarchy value, or @ field (see Account Segment Syntax for more information).

Use the following links to access ledger-specific GXL information: