Sample 15-A: Basic Calculated Row

This sample report 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" }
    ! 

This report script, ROWCALC1.REP, is available in the \ARBORPATH\App\Demo\Basic directory, and is displayed in Enterprise View in Administration Services.