Returns the maximum value among the results of the expressions in the specified member list, with options to skip missing or zero values (in contrast with the @MAX function, which cannot ignore these values).

Syntax

`@MAXS (SKIPNONE | SKIPMISSING | SKIPZERO | SKIPBOTH, expList)`

Parameter | Description |
---|---|

SKIPNONE | Includes all cells specified in expList in the operation, regardless of their content |

SKIPMISSING | Ignores all #MISSING values |

SKIPZERO | Ignores all 0 values |

SKIPBOTH | Ignores all 0 and #MISSING values |

expList | Comma-delimited list of members, variable names, functions, or numeric expressions, all of which return numeric values |

Notes

@MAXS (SKIPMISSING, expList) is equivalent to @MAX (expList).

Because #MISSING values are greater than negative data values and less than positive data values, if the data being calculated includes only negative and #MISSING values, @MAXS returns #MISSING.

If the data being calculated includes only negative, 0, and #MISSING values, @MAXS may return either #MISSING or 0 values in an unpredictable manner.

Example

For both examples, assume a database similar to Sample Basic. The Measures dimension includes two members: COGS (cost of goods sold) and OtherInc_Exp (miscellaneous income and expenses). The data can include 0 and #MISSING values.

Qtr1_Max = @MAXS(SKIPBOTH, Jan:Mar);

This example ignores #MISSING and 0 values for all members of the Measures dimension. This example produces the following results:

Jan Feb Mar Qtr1_Max ======== ======== ======== ======== COGS #MISSING 1500 2300 2300 OtherInc_Exp -500 -350 0 -350

Qtr1_Max = @MAXS(SKIPNONE, Jan:Mar);

This example includes #MISSING and 0 values in the calculation, for all members of the Measures dimension. This example produces the following results:

Jan Feb Mar Qtr1_Max ======== ======== ======== ======== COGS #MISSING 1500 2300 2300 OtherInc_Exp -500 -350 0 0

See Also