Technical data

Chapter 11 Using Built-in Functions in Analytic M odels
Returns
The r ight most C
ount characters of Text.
Example
RIGHT("StringFun", 3) returns Fun.
ROUND
Syntax
ROUND(Data, Integer)
Note. The Integer argument is optional.
Description
The ROUND funct
ion—when you use only the first argument—returns the value of Data rounded to the
nearest whole
number. If you use the optional second argument, the ROUND function returns the value of
Data rounded t
o the number of decimal places that you specify with the Integer argument.
The default value for the Integer argument is zero.
Example
The following examples employ the ROUND built-in function:
• ROUND(14) ret
urns 14.
• ROUND(14.3) r
eturns 14.
• ROUND(14, 0) r
eturns 14.
• ROUND(14.3, 0
) returns 14.
• ROUND(14.5, 0
) returns 15.
• ROUND(14.7, 0
) returns 15.
• ROUND(34.567
89, 4) returns 34.5679.
SELF
Syntax
SELF()
Description
The SELF function returns the current value of the data cube that is being calculated. The SELF function
recalculates the data cube only if a certain condition is true; otherwise, the data cube retains its current value.
Returns
The current value of the data cube being calculated.
Copyright © 1988-2007, Oracl e. All rights reserved. 187