1. Designing with Financial Reporting Web Studio for Oracle Enterprise Performance Management Cloud
  2. Designing Reports with Financial Reporting Web Studio
  3. Working With Grids
  4. Working With Rows and Columns in Grids
  5. Defining Formula Rows and Columns
  6. Formula Row and Column Syntax

Formula Row and Column Syntax

Syntax:


            gridname.row\column[x].property
Argument Description
gridname Name of the grid. Grid names cannot include spaces. When specifying the full gridname notation, you must also indicate the row, column, or cell.
x Row or column, number, and property.

Example 1

Add all elements in row 3 of mygrid1. 

mygrid1.row[3].sum

Example 2

Return the sum of the nth column: 


              mygrid2.column[C].sum

Example 3

Returns the absolute value of the cell located at the intersection of row 5 and column B in the current grid:

ABS([5,B])