Functions
Functions allow obtaining values through the transformation of others. The following is a list of functions divided into categories, according to their typical use.
Mathematical functions
| Function | Comments |
|---|---|
| CelsiusToFahrenheit | Converts a temperature in degrees Celsius to degrees Fahrenheit. |
| FahrenheitToCelsius | Converts a temperature in degrees Fahrenheit to degrees Celsius. |
| Max | Returns the maximum value among a series of values. |
| Min | Returns the minimum value among a series of values. |
| Power | Returns the result of raising a given number to a given power. |
| Round | Rounds a number to the specified number of decimal places. |
| Sqrt | Calculates the square root of a number. |
| Trunc | Truncates a number, removing the fractional part. |
String handling functions
| Function | Comments |
|---|---|
| LowerCase | Converts all characters in a string to lowercase. |
| StringClean | Cleans a string by removing all unwanted characters. |
| StringPart | Returns a part of a string that contains sub-strings. |
| UpperCase | Converts all characters in a string to uppercase. |
Interpolation functions
| Function | Comments |
|---|---|
| LinearInterpolation | Performs a linear interpolation between a series of given points. |
JSON handling functions
| Function | Comments |
|---|---|
| JsonField | Gets the value of a field within a text expressed in JSON format. |
Other functions
| Function | Comments |
|---|---|
| Error | Generates an error condition containing the specified message. |
| HexToNumber | Converts a number in hexadecimal format (string) to a number. |
| If | Returns a value, between two given values, based on a condition. |
| ToBoolean | Converts a value of any type to boolean. |
| ToNumber | Converts a value of any type to numeric. |
| ToString | Converts a value of any type to string. |
Última atualização em
Relational operators
Relational operators are applied in comparison operations, and the result of their application is always a boolean value (true / false).
Funções Matemáticas
Funções matemáticas disponíveis no motor de expressões, incluindo conversão de temperatura, mín/máx, potência, arredondamento, raiz quadrada e truncamento.