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 |