Data Transformation Engine Functions and Expressions Reference Guide

Chapter 2 - Using Functions List of Functions by Category
Functions and Expressions Reference Guide
44
Function Description
COUNTABS
Counts the number of objects, valid and invalid, in a series
FROMBASETEN
Converts an integer to a text item that can be interpreted as a
number using positional notation of the base specified
INT
Returns the integer portion of a number
MAX
Returns the maximum value from a series of number, date,
time, or text values
MIN
Returns the minimum value from a series of number, date, time,
or text values
MOD
Returns the modulus after a number is divided by an integer
ROUND
Rounds a number to a specified number of decimal places or to
a whole number if no decimal places are specified
SQRT
Returns the square root of a number
SUM
Calculates the sum of a series of numbers
TOBASETEN
Converts a text item that can be interpreted as a number, using
positional notation of the base specified, to a base 10 number
TRUNCATE
Truncates a number to a specified number of decimal places, or,
if the decimal places are not specified, truncates it to an integer
Bit Manipulation and Testing Functions
Function Description
SETOFF
Sets to 0 (zero) a specified bit in a binary number
SETON
Sets to 1 a specified bit in a binary number
TESTOFF
Tests a specified bit in a binary number to see whether it is off
TESTON
Tests a specified bit in a binary number to see whether it is on