Technical data

Using Built-in Functio ns in Analytic Models Chapter 11
• CHANGE(MONTHS, GROSS_MARGIN)
TRUNC
Syntax
TRUNC(Data)
Description
The TRUNC func
tion returns the value of Data with the decimals truncated.
Returns
The value of Data with the decimals truncated.
Example
The following examples employ the TRUNC built-in function:
• TRUNC(14) ret
urns 14.
• TRUNC(14.3) r
eturns 14.
• TRUNC(14.7) r
eturns 14.
UPPER
Syntax
UPPER(Text)
Description
The UPPER function returns Text converted to uppercase.
Returns
Text converted to upper case.
Example
UPPER("Strin
gFun") returns STRINGFUN.
VAR
Syntax
VA R (Dimensi
on, Values, {Type}, {Condition})
Description
The VAR function returns the variance of Va l u e s.IfType is zero or omitted, VAR calculates a population
variance; otherwise, VAR calculates a s ample variance. If Condition is omitted, the function uses all Va l u e s .If
Condition is included, the function uses only those Va l u e s where Condition is true.
196 Copyright © 1988-2007, Oracl e. All rights reserved.