The expression model offers functions that accept different types of expressions as arguments, including type conversion, aggregation, and ranking. ...
Continue reading...

A table of pseudo-functions with names starting with underscores maps all unary and binary operators. It provides uniformity in calling expressions. ...
Continue reading...

A list of functions for data type conversion, numeric calculations, filtering, and text manipulation. ...
Continue reading...

Examples of functions to add periods, get specific date parts, test date ranges, and evaluate if a date is within a specific period. GetDate()Date/timeCurren...
Continue reading...

Various aggregating functions to compute aggregated values from a set of values based on a source value and other arguments. ...
Continue reading...

Examples include functions to get the length of a string, remove spaces, extract substrings, and change case. The following functions can be used to be used ...
Continue reading...

Functions that work with "self-ref" hierarchies defined in tables. They allow to select certain records in a hierarchy and analyze relations between records....
Continue reading...

Functions in data analysis allow the aggregation of values from compound expressions like grids or numeric lists. ...
Continue reading...

Functions for aggregating values of "vector" (compound) expressions, like grids or numeric lists. Includes boolean, numeric and any types. ...
Continue reading...

Geolocation functions: point(lat, long), lat(point), long(point), distance(point1, point2), toGeo(text), and ToText(geolocation). ...
Continue reading...

Recoding definitions map source values into text codes using rules. Rules can be of text, integer or range types, and must not overlap. ...
Continue reading...

Recoding functions recode source values into a number of categories. Input for recoding is either numeric, text or date value. Input value is mapped to a cer...
Continue reading...

Sorting criteria define the value and direction for sorting in ranking functions. Each criterion includes an expression of comparable type and direction. ...
Continue reading...

FunctionDescriptionAbs(<x>) Calculates an absolute value of its numeric argument (integer or floating-point)Ceil(<x>) Calculates a minimal integer greater or...
Continue reading...

Function Description Convert(source_value, target_type) Converts a value to the specified type. Value types can be converted according to the type c...
Continue reading...

FunctionDescriptionIsNull(a1, a2) The value of a1 if it is not null, otherwise a2. a2 must be convertible to the type of a1. Between(value, lower, upper) T...
Continue reading...

Ranking functions calculate ranks of values within a series of values according to the specified sorting criteria.All ranking functions accept the same set o...
Continue reading...