1. Getting Started with Your Financials Implementation
  2. Define Range Functions for a Financial Reporting Report

Define Range Functions for a Financial Reporting Report

This is the third of six topics on designing a financial report with Financial Reporting Web Studio.

In this example, you define a range function to report across multiple accounting periods. You configure the range to present balances for the last 12 months from the period selected at runtime.

Before you start, do the steps described in these topics.

  1. Define a Basic Financial Report Using the Reporting Web Studio

  2. Add Formulas to a Financial Reporting Report

Now follow these steps.

  1. Double-click the Accounting Period cell. The Select Members dialog box opens.

  2. Remove the default accounting period from the Selected area by clicking it to select it and then clicking the Remove from Selected icon.

  3. Click the Functions tab.

  4. Select Range from the list.

  5. Click the Add to Selected icon. The Range dialog box opens.

  6. Define the starting member for the range.

    1. On the Start Member row, click the Lookup Selection icon in the Value column.

    2. Click the Functions tab.

    3. Select the Relative Member function to define the periods that display on the report relative to the period specified at runtime.

    4. Click OK. The Relative Member dialog box opens.

    5. On the Member row, click the Lookup Selection icon in the Value column.

    6. Select Current Point of View for Accounting Period so you can enter the starting period for the report.

    7. Click OK.

    8. On the Offset row, enter -11 in the Value field.

      The offset determines the first period of the range. The starting period in the range function is always the oldest period. Because this is a rolling 12 period report, enter -11 to include the 11 periods prior to the period you enter at runtime. The member selection for the End Member parameter determines period 12.

    9. Click OK.

  7. Define the ending member for the range.

    1. On the End Member row, click the Lookup Selection icon in the Value column.

    2. Select Current Point of View for Accounting Period.

    3. Click OK.

    4. Click OK to close the Range dialog box.

    5. Click OK to close the Select Members dialog box.

  8. Save the report and leave it open for the next topic, which is defining a grid point of view. Optionally preview the report.