Building Time Formulas

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

@basepd(+1(@year))

Note:

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

  To build time formulas:

  1. From a freestyle report, access Build Time Formula.

    See Linking Data to Freestyle Reports by Assigning Cell Attributes.

  2. In Formula, create time formulas by inserting operators and double-clicking functions. See:

  3. Optional: Select Show User Labels to display user-defined time periods.

    See Changing Time Period Labels.

  4. Click OK.