Skip to main content

BPCS 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 BPCS ledgers:

Field Description

Datagroup (Version 4.05)

Specify the data type. Valid options are:

  • CURRENT
  • PRIOR
  • FUTURE
  • BUDGETA
  • BUDGETB
  • CBnn (where nn is the budget number)

Ledger (Version 6+)

Specify the CEA ledger.

Book (Version 6+)

Specify the CEA book.

Year (Version 6+)

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
  • PERJ
  • QTRJ
  • YTDJ

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.

See Build a Template with Formula Builder for more information.

Was this article helpful?

We're sorry to hear that.

Powered by Zendesk