Technical data

Using Built-in Functio ns in Analytic Models Chapter 11

GROW(MONTHS, SALES_START, ANNUAL_GROWTH / 12)

Note that you mu

st divide ANNUAL_GROWTH by 12, because the GROW function expects a growth rate

per member,an

d the members in this case are months.

Note. For the GROW function to return meaningful results, the Start Value and Growth Rate arguments should

not use the dimension indicated by the dimension argument. For example, if you are c alculating monthly

values, the Start Value and Growth Rate arguments should not use the MONTHS dimension.

Syntax

IF(Condition, Result if True, Result if False)

Description

The IF function returns Result if True if Condition is true; otherwise, the function returns Result if False.

Returns

Result if True

if Condition is true; otherwise, the function returns Result if False.

Example

For example, suppose a company awards its salespeople a 10 percent commission o n sales of at least USD

20,000, and a 5 percent commission on sales under USD 20,000. You create a COMMISSION cube and can

compute the commission for each person as follows:

IF(SALES >= 20000, 0.1 * SALES, 0.05 * SALES)

The IF function in this formula tests whether SALES is greater than or equal to 20000. If so, the function

returns 10 percent of SALES; otherwise, the function returns 5 percent of SALES.

INC

Syntax

INC(Original Value, Amount to Increment)

Description

The INC funct

ionreturnsanincrementedvaluebasedonanoriginal value and the amount to increment.

Returns

An incremented value based on an original value and the amount to increment.

Example

INC(&NumMonths, &EndMonth - &StartMonth - 1)

This formula adds the months between the start and end month to the variable &NumMonths.