Scales the data in the report by multiplying it by a numeric value.
{ SCALE factor [ columnList ] }
| factor | Numeric value by which all output values are multiplied. The result is a scaled value. |
| columnList | Optional. List of column numbers that this command affects. |
This command affects only the columns specified in the command or all columns if none are specified. Stored data is not affected by this command.
The command {SCALE .01} multiplies the data values in the second report by .01.
<PAGE (Market, Accounts, Scenario)
Chicago Sales Actual
<COLUMN (Year)
<CHILDREN Year
<ROW (Product)
<CHILDREN Audio
!
{SCALE 2}
Chicago Sales Actual
<CHILDREN Year
<CHILDREN Audio
!
This example produces the following report:
Chicago Sales Actual
Qtr1 Qtr2 Qtr3 Qtr4
======= ====== ====== ======
Stereo 2,591 2,476 2,567 3,035
Compact_Disc 3,150 3,021 3,032 3,974
Chicago Sales Actual
Qtr1 Qtr2 Qtr3 Qtr4
======= ====== ====== ======
Stereo 5,182 4,952 5,134 6,070
Compact_Disc 6,300 6,042 6,064 7,948
|
BRACKETS
COMMAS
DECIMAL
SUPBRACKETS
SUPCOMMAS
| ©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |