Oracle GXD

For Oracle ledgers, the GXD formula is used to retrieve the description of a single account segment.

Syntax

=GXD("Segment Num","Value","Ledger")

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

Parameters

The following are GXD formula parameters for Oracle ledgers:

Segment Num

Identifies the segment number of the account string for which to retrieve the description.

Value

Identifies the value of the account segment for which to retrieve the description.

Ledger

Identifies the ledger (set of books) from which to retrieve the description. Entry is optional if only one ledger is referenced in the workbook.

Formula Example: Using a Single Segment

=GXD("3","1110","Vision Operations (USA)")

Retrieves the description for segment 3, value 1110, from the Vision Operations (USA) set of books.

Formula Example: Using Multiple Segments

=GXD(("1","01")& "-" &GXD("3","1640")

Retrieves the description for segment 1, value 01, and concatenates the description for segment 3, value 1640.

See GL Reporting and Create or Maintain GL Formulas for more information.