Scales the data in the report by multiplying it by a numeric value.
Syntax
{ SCALE factor [ columnList ] }
Parameter | Description |
---|---|
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. |
Notes
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.
Example
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
See Also