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 to first parameter 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: truval 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])
Sine	sin(x)
Square Root	sqrt(x)
Substring	substring(str, start, [end])
Tangent	tan(x)
To Date	todate(str, pattern)
To Double	todouble(x)
To Integer	toint(x)
To Lowercase	tolower(str)
To String	tostring(data)
To Timestamp	totimestamp(str, pattern)
To Uppercase	toupper(str)