MIPMap supported functions

label	expression	Description
Abs	abs(x)	Returns the absolute value of the same type / Returns the Modulus for Complex
Append	append(str1, str2)	Appends second parameter str2 to first parameter str as string
Ceiling	ceil(x)	The smallest integer above the number x
Contains	contains(str, subStr)	Returns True if str contains the subStr at least once
ContainCount	containCount(str, subStr)	Returns the number of occurrences of subStr within str
Cosine	cos(x)	Cosine of angle x
Current Year	currentYear()	Returns current year
Date	date()	Returns current date
DateTime	datetime()	Returns current date in datetime format
Exponential	exp(x)	The result of the exponential function (e^x)
Floor	floor(x)	The smallest integer below that number x
If	if(cond, trueval, falseval)	The if function: trueval will be returned if cond >0 or True, and falseval if cond <=0 or False
Index Of	indexof(str, subStr)	Returns the position of the first occurrence of the subStr in the str.
Is Not Null	isNotNull(arg)	Tests if the arg is not null
Is Null	isNull(arg)	Tests if the arg is null
Is Numeric	isNumeric(str)	Test if the str is numeric
Length	len(str)	Returns the length of a string
Log	log(x)	Logarithm base 10
Ln	ln(x)	Natural logarithm
Modulus	mod(x,y)	Calculates the modules of x % y of the arguments
New Id	newId()	Gets the next number in a sequence
Null	null()	Returns null value
Power	pow(x,y)	Computes the y-th power of a number x (x^y)
Replace	replace(str, text1, text2)	In the first argument str , find all occurrences of the text1 and and replace them with text2
Round,	round(x,[y])	The closest integer to the argument, the second argument is optional and refers to decimal places
Sine	sin(x)	The Sine of angle x
Square Root	sqrt(x)	The Squared root of x
Substring	substring(str, start, [end])	Extracts a substring of str, start is starting index, end is optional for ending index
Tangent	tan(x)	Tangent of angle x
To Date	todate(str, pattern)	Converts a str to date format given pattern, e.g. "DD/MM/YYYY"
To Double	todouble(x)	Returns the double value of x
To Integer	toint(x)	Returns the integer value of x
To Lowercase	tolower(str)	Converts the str to lower case letters
To String	tostring(data)	Converts data type to string
To Timestamp	totimestamp(str, pattern)	Converts a str to datetime format given pattern, e.g. "DD/MM/YYYY hh:mm:ss"
To Uppercase	toupper(str)	Converts the str to upper case letters