Returns the mode (the most frequently occurring value) in the specified data set (expList).
@MODE (SKIPNONE | SKIPMISSING | SKIPZERO | SKIPBOTH, expList)
SKIPNONE | Includes all cells specified in expList, regardless of their content, during calculation of the mode. |
SKIPMISSING | Excludes all #MISSING values from expList during
calculation of the mode. |
SKIPZERO | Excludes all zero (0) values from expList during calculation of the mode. |
SKIPBOTH | Excludes all zero (0) values and #MISSING values from
expList during calculation of the mode. |
expList | Comma-delimited list of member specifications, variable names, functions, or numeric expressions. expList provides a list of numeric values across which the mode is calculated. |
#MISSING
is the mode of expList, @MODE
returns #MISSING
unless SKIPMISSING or SKIPBOTH is specified.
If you specify SKIPMISSING or SKIPBOTH and all values in expList
are #MISSING
, @MODE returns #MISSING
.
If you specify SKIPZERO or SKIPBOTH and all values in expList are
0, @MODE returns #MISSING
.The following example calculates the mode of the units sold for the Central region and uses the @RANGE function to generate expList:
FIX (Central) "Mode" = @MODE(SKIPMISSING, @RANGE(Sales,@CHILDREN(Central))); ENDFIX
This example produces the following report:
Colas Actual Jan Units Sold ========== Units Sold Illinois 3 Ohio 2 Wisconsin 3 Missouri #MI Iowa 0 Colorado 6 Central 14 Mode Central 3
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |