Technical data

Chapter 11 Using Built-in Functions in Analytic M odels

Description

The ASC functio

n returns the first character of the Text argument to its ASCII equivalent number (for example,

a number b etwe

en 0-255). Use this function to convert a character into its ASCII value.

Returns

The first character of the Text argument to its ASCII equivalent number.

Example

For a cube formatted as a number, ASC("ABC") returns the 65.

ASIN

Syntax

ASIN(Data)

Description

The ASIN funct

ion returns the arc-sine of Data. The result is the angle (in radians) whose sine equals Data.

The value of Data must fall between –1 and 1; otherwise, ASIN returns an error value.

To convert f rom radians to degrees, multiply by 180 / PI( ). (The PI function returns the value of PI.)

Returns

The arc-sine o

f Data.

Example

The following examples employ the ASIN built-in function:

• ASIN(0.5) returns 0.5235987756 (angle in radians).

• ASIN(0.5) * 180 / PI( ) returns 30 (angle in degrees).

• ASIN(SQRT(2) / 2) returns 0.7853981634 (angle in radians).

• ASIN(SQRT(2) / 2) * 180 / PI( ) returns 45 (angle in degrees).

Syntax

AT(Dimension, Member, Data)

Description

The AT functi

on looks up the value of Data for a particular member in a dimension.

YoucanusetheATfunctioninthefollowingways:

• You can look up a value at a particular position in the dimension.

• You can look up a value for a particular member by name.