Numeric Extension Functions Tool Palette

Numeric Extension Functions tool palette

NameDescription
absolute valueReturns the absolute value of the input value.
averageReturns the numeric average of the values of the specified nodes.
decodeReturns the input string decoded into an integer
logReturns the log value of input value.
maximumReturns the greater of two input values.
maximum in listReturns the maximum value in a list of values.
minimumReturns the lesser of two input values.
minimum in listReturns the minimum value in a list of values.
powReturns the input value raised to the power of the specified exponent.
randomReturns a random number.
rintReturns the closest value that is equal to a mathematical integer.
scaleReturns the scaled value of the input. The scale is the number of digits to the right of the decimal point.
square rootReturns the square root of the input value.
sum totalReturns the total of the specified nodes, after multiplying each node.

Supported Transformation Functions

Boolean Functions Tool Palette

Conditional Logic Functions Tool Palette

DateTime Extension Functions Tool Palette

Node Set Functions Tool Palette

Number Functions Tool Palette

String Extension Functions Tool Palette

String Functions Tool Palette

Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com