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.