Analyst GXD

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

Syntax

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

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

Parameters

The following are GXD formula parameters for Analyst 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.

Formula Example: Using a Single Segment

=GXD("2","1200")

Retrieves the description of account segment 2, value 1200.

Formula Example: Using Multiple Segments

=GXD("1","10")& "-" &GXD("2","1200")

Retrieves the description of company segment 10, and concatenates the description of account segment 1200.

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