SCALE

Scales the data in the report by multiplying it by a numeric value.

Syntax

{ SCALE factor [ columnList ] }

Parameters

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 following report script is designed for the Demo Basic cube, available in the gallery. 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