1. Designing with Reports for Oracle Enterprise Performance Management Cloud
  2. Working with Grids
  3. Working With Rows and Columns in Grids
  4. Defining Formula Rows and Columns
  5. Calculating at the Cell Level

Calculating at the Cell Level

You can create a custom cell-level formula on cells in a formula row or column.

Figure 4-31 shows an example of a cell that is calculated to display the % variance. Cell D4 displays the % variance between the sum of "Jan" and the sum of "Feb"; specifically, ((356-350)/350) *100=1.71%. A cell level formula gives the intended result by placing a custom formula in the cell D4. The formula needed to get the correct result is (([B]-[A])/[A])* 100.

Figure 4-31 Reason for Using Cell Level Calculation


An example of a custom cell-level formula on cells in a formula row or column

To calculate at the cell level:

  1. Select a formula cell or cells.
  2. In the formula bar at the top of the Report Designer, click formula, and perform an action:

    • Select Use the Column/Row Formula to use the default formula for the column or row.

    • Select Custom Formula to create your own formula. Enter the formula in the formula text box to the right, or click formula functions to select from a list of formulas.

    See Using the Formula Bar.