Technical data

Using Built-in Functio ns in Analytic Models Chapter 11

MIN(PRODUCTS, UNITS_SOLD, ADVERTISING_BY_PRODUCT >= 10000)

In this case, th

e 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.

See Also

Chapter 11, “Using Bui lt -i n Functions in Analytic Models,” DAVG, page 148

DSUM

Syntax

DSUM(Dimension, {Data}, {Condition})

Description

The DSUM funct

ion returns the sum of Data for the members in Dimension where Condition is True. If

Condition is o

mitted, DSUM returns the sum of Data for all members in Dim ension.IfData is omitted, DSUM

returns the su

m 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 total units sold for all products:

DSUM(PRODUCTS, UNITS_SOLD)

The DSUM function does not include a condition, so the function computes the sum of UNITS_SOLD for all

members in the PRODUCTS dimension. Use the following formula to calculate the sum of units sold for all

products with advertising of at least 10,000 USD:

DSUM(PRODUCTS, UNITS_SOLD, ADVERTISING_BY_PRODUCT >= 10000)

In this case, the function finds the sum of UNITS_SOLD only for the products where

ADVERTISING_BY_PRODUCT is greater than or equal to 10000.

For an exampl

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

You can use the DSUM function without the Data argument to exercise complete control over the calculation

of dimension totals for a particular data cube.