Skip to main content

Movex Build a Template for GXL

As fields in the Formula Builder > GXL panel vary based on the selected ledger, use the following table to enter unique data unique to Movex ledgers:

Field Description

Budget Number

If applicable, specify the budget number from which to retrieve data. Leave blank to retrieve actual data.

Budget Revision

If applicable, specify the budget revision from which to retrieve data. Entry is required if a budget number is specified.

Year

Click the drop-down list, and select the reporting year.

Format

Click the drop-down list and select the time range for which to retrieve data. Valid formats are:

  • PER
  • QTR
  • DQTR
  • YTD
  • LTD
  • RANGE

Period

Click the drop-down list, and select the corresponding period, quarter number, or range of periods (for example, 1.5 for periods 1 through 5) for the specified format.

Balance Key

Click the drop-down list, and select the balance key to be used to retrieve data.

Stat

Enter Y to return statistic values, otherwise enter N.

Exchange Rate

If applicable, click the drop-down list, and select the exchange rate to be multiplied by the balances, to calculate the reporting amounts.

See Build a Template with Formula Builder for more information.

Was this article helpful?

We're sorry to hear that.

Powered by Zendesk