1. Scripting Reference for Oracle Essbase
  2. Report Writer
  3. Examples of Report Scripts
  4. Sample 15: Calculating Rows
  5. Sample 15-A: Basic Calculated Row

Sample 15-A: Basic Calculated Row

This Essbase report script sample demonstrates the basic form of the CALCULATE ROW command. 

                          Audio Actual Sales
                           Jan      Feb      Mar 
                      ======== ======== ======== 

Boston                   1,985    1,801    1,954 
New_York                 2,310    2,082    2,259 
Chicago                  2,043    1,884    1,814 

Total Sales              6,338    5,767    6,027 
Avg Sales                2,113    1,922    2,009

Use the following script to create Sample 15-A:

     Audio Actual Sales
     Jan Feb Mar

{ CALCULATE ROW "Total Sales" }    //create new calculated row
Boston
New_York
Chicago

{ SKIP
  CALCULATE ROW "Avg Sales" = "Total Sales" /3 
  PRINTROW "Total Sales"
  PRINTROW "Avg Sales" }
    !