DMIN

Syntax

DMIN (Dimension, Data, {Condition})

Description

The DMIN function returns the minimum of Data for the members in Dimension where Condition is True. If Condition is omitted, DMIN returns the minimum of Data for all members in Dimension. If Data is omitted, DMIN returns the minimum of the data cube being calculated, for all members up to the current member in Dimension.

Returns

The minimum of Data for the members in Dimension where Condition is True. If Condition is omitted, DMIN returns the minimum of Data for all members in Dimension. If Data is omitted, DMIN returns the minimum of the data cube being calculated, for all members up to the current member in Dimension.

Example

Suppose that an analytic model contains a data cube called ADVERTISING_BY_PRODUCT and a data cube called UNITS_SOLD. Both data cubes use a dimension called PRODUCTS. Use the following formula to calculate the minimum units sold for all products:

DMIN(PRODUCTS, UNITS_SOLD)

The DMIN function does not include a condition, so the function finds the minimum of UNITS_SOLD for all members in the PRODUCTS dimension. Use the following formula to calculate the minimum units sold for all products with advertising of at least 10000 USD:

MIN(PRODUCTS, UNITS_SOLD, ADVERTISING_BY_PRODUCT >= 10000)

In this case, the function finds the minimum units sold only for the products where ADVERTISING_BY_PRODUCT is greater than or equal to 10000.

For an example of how to tabulate data for a series of ranges, see the entry for the DAVG function.