Technical data

Chapter 11 Using Built-in Functions in Analytic M odels

Returns

The value of e.

Example

These examples employ the E built-in function:

• E( ) returns 2.7182818285.

• E( ) ^ 5 returns 148.4131591026 (e raised to the 5th power).

FIND

Syntax

FIND(Text Original String, Te xt Sub String, Number Starting Position)

Description

Use the FIND fu

nction to find a substring in the original string passed in starting from a specified start

position in th

e original string.

Parameters

Parameter Description

Text Original String The text of the original string.

Text Sub String The substring text to find.

Number Star

ting Position

The start po

sition in the orig inal string.

Returns

The position of the substring in the original string. The index is 1-based.

Example

The following formula finds the account name that begins with Expense:

IF(FIND(ACCOUNT_NAME, "Expense", 1) = 1, #TRUE, #FALSE)

FIRST

Syntax

FIRST(Dimension)

Description

Use the FIRST function to test for special cases that occur when the first member of a dimension is being

calculated.