The Cast function changes the resulting data type. For example, this is helpful if a function returns a value of the data type Integer and you want to change it with a substring() function
Name |
Syntax |
Example |
Boolean |
boolean(arg) |
boolean(1) = true |
Integer |
integer(arg) |
integer(1.2) =1 |
Number |
number(arg) |
number("123") = 123.0 |
String |
string(arg) |
string(0815) = 815.0 |
A peculiarity of the formula parsers is that Boolean values are not represented as TRUE or FALSE, but as 1.0 or 0.0. Consequently, an explicit Boolean cast has to be executed for expressions which are to return a string result TRUE or FALSE. An example is shown below:
Expression |
Result |
1>2 |
0.0 |
boolean(1>2) |
FALSE |