Building Time Formulas

You use Build Time Formula to define formulas to reference time periods. For example, to reference data for the current and next year, you use @basepd:

@basepd(+1(@year))

Note:

You use Time Period to change the base period. See Defining, Deleting, and Displaying Time Periods.

To build time formulas:

From a freestyle report, access Build Time Formula.
See Linking Data to Freestyle Reports by Assigning Cell Attributes.
In Formula, build a time formula.
- To enter an operator, click a button:
  - +
  - –
  - (
  - )
- In Function, double-click functions:
  - @firstpd
    See @firstpd.
  - @lasthist
    See @lasthist, vXXXX(@lasthist).
  - @firstfore
    See @isfirstfore.·
  - @lastfore
    See @lastfore, vXXXX(@lastfore).·
  - @closing
    See @closing.·
  - @deal
    See @deal.·
  - @opening
    See @opening.·
  - @basepd
    See @basepd.
- In Period Labels, double-click time periods.
Optional: Select Show User Labels to display user-defined time periods.
See Changing Time Period Labels.
Click OK.