East Actual Budget Var Jan Feb Mar Qtr1 Jan Feb Mar Q1 Q1 ====== ====== ====== ====== ====== ====== ====== ====== ======= 1,295 1,132 553 2,980 Tele~ Profit 1,240 950 950 3,140 (160) 25 27 14 66 Profit_% 26 22 22 70 (4) 56 62 59 177 Margin_% 60 60 60 180 (3) 1,417 1,120 898 3,435 VCR Profit 1,466 1,161 1,161 3,788 (353) 33 30 24 87 Profit_% 35 31 31 98 (10) 61 61 62 183 Margin_% 63 63 63 189 (6) 400 272 256 928 Cam~ Profit 528 360 360 1,247 (319) 15 11 10 36 Profit_% 19 13 13 45 (10) 70 70 70 211 Margin_% 71 71 71 213 (2) 3,112 2,524 1,707 7,343 Visu~ Profit 3,234 2,471 2,471 8,175 (832) 25 24 17 66 Profit_% 27 23 23 74 (7) 61 63 63 187 Margin_% 64 64 64 191 (4)
Use the following script to create Sample 14-A:
<PAGE(Market) East <COLUMN (Scenario, Year) Actual Budget Jan Feb Mar { CALCULATE COLUMN "Qtr1" = 2 : 4 CALCULATE COLUMN "Q1" = 5 : 7 CALCULATE COLUMN "Var~Q1" = 8 - 9 ORDER 2,3,4,8,0,1,5,6,7,9 WIDTH 7 WIDTH 10 0 1 } <ROW (Product, Accounts) <ICHILDREN Visual <CHILDREN Accounts !
This report script, COLCALC2.REP, is available in the \ARBORPATH\App\Demo\Basic directory, and is displayed in Enterprise View in Administration Services.