Expression Builder

Converts null values to the value specified in the function (defaults to 0).

Retrieves each distinct value of a selected field.

The system inserts the selected date field into an expression, converting the field into an actual date type field. Valid values are:

• YYDDD: Julian date format used by Infinium.
• CYYDDD: Julian date format used by JD Edwards.
• YYYYDDD: Julian date format used by Jack Henry.
• YYYYMMDD: date format used by BPCS.

Note: Date formats are not exclusive to the ledgers listed above.

Inserts the parameter as a Smart Parm, number, or text.

Inserts the %GEXDROW% keyword, replacing the Excel row number, when used in a GEXD formula.

Inserts the %USER% keyword, replacing the user name in the connection to the data.

Inserts the %WINDOWSUSER% keyword, replacing the Windows user name, when executing the query.

Inserts the %APPUSER% keyword, replacing the application user name from Application Configurator, when executing the query.

Click the drop-down list to access additional %IF and %LOOP functions.

Inserts a loop statement, allowing the query to loop through fields, and summarize them based on the user-defined parameters of the loop counter. The loop continues to process from the first counter, until it hits the second counter.

Inserts the %LOOPCOUNT% keyword.

Inserts the %LOOPCOUNT2% keyword. The 2 may then be modified to a different number, to indicate the number of characters or digits to display for the value.

Inserts a basic IF-THEN-ELSE statement, which may then be modified.

Inserts the expression of the current date in the query.

Inserts the (CURRENT DATE - 90 DAYS) expression. The - 90 may then be modified to a different value.

Valid values are:

• +
• -
• /
• *

Valid values are:

• =
• <
• >
• <>
• BETWEEN
• LIKE
• DISTINCT
• IN('Value1', 'Value2')

Valid values are:

• AND
• OR
• NOT