Formula
Use the math.formula template function to enter a mathematical formula in plain text. When the template is parsed, it is converted to the relevant math. function. This is done the first time the template is used after a platform reload (i.e. on compile, release ring switch, or new release).
Both plain text formulas and standard math. functions have similar performance, although there can be a small performance gain on first use when using the standard functions.
The following table contains examples of valid formula templates.
| Example formula template | Result | Remark |
|---|---|---|
| Basic math | ||
3-5 | -2 | |
3*5 | 15 | |
3/5 | 0.6 | |
3+5*7 | 38 | Normal ordering |
(3+5)*7 | 56 | Use parentheses to force ordering |
3/5*7 | 4.2 | Divide and multiply are equal |
| Other functions | ||
add(3;5) | 8 | The mathematical function of addition |
AdD(3;5) | 8 | Everything is case insensitive |
subtract(3;5) | -2 | |
multiply(3;5) | 15 | |
divide(3;5) | 0.6 | |
floor(3.1415) | 3 | |
round(3.1415) | 3 | |
ceil(3.1415) | 4 | |
round(3.1415;3) | 3,142 | To separate the argument from the rounding decimal, use a semicolon ; |
if(3==5){3}else{5} | 5 | Supported operators are ==, <, <=, >, >=, <>, !=, !==, where the last three are all the same |
| White spaces | ||
1 + 2 | 3 | White spaces and tabs are trimmed |
1 + 2 | 3 | New lines are trimmed |
| Strings | ||
"abc" | "ABC" | A string is placed between quotation marks |
"monkey mies" | "monkey mies" | White spaces and new lines in text are not trimmed |
"<a href=\\"https://www.google.com\\">This is a link</a>" | <a href="https://www.google.com">This is a link</a> | \" is used to escape the quotes " in strings \\ is used to escape the backslashes \ in strings |
"ab" & 3 | "ab3" | String concatenation uses ampersand & |
"ab" "c" | ERROR | Always separate arguments with an operator (for example with & to concatenate a string) |
"ab" 3 | ERROR | As above |
"ab" & 3+4 | "ab7" | Unlike other languages, addition and subtraction operations are performed prior to string concatenation |
add("1";2) | ERROR | Mathematical functions cannot be applied to strings |
add(cast("1"; integer); 2) | 3 | |
"ab" & cast(3.14; integer) | ERROR | A template part (an argument is string concatenation) cannot be casted |
cast("1"&"2"; integer) | ERROR | The top level is a (trivial) String concat. Use the return type of the template instead. |
"ab" & add(cast(3.14;integer);0) | "ab3" | A workaround is to introduce a template. |
if("a" & "b" == "ab"){ "yes" }else{ "no" } | "yes" | Strings can be used in combination with the "if" function. The "if" and the "cast" function are the only functions that accept a string as an argument |
| Money & cast | ||
cast( "{\\"currency\\":\\"EUR\\",\\"value\\": 3.14}" ; money)+ cast( "{\\"currency\\":\\ "EUR\\",\\"value\\": 2.71}" ; money) | Money: {"currency":"EUR","value": 5.84} | money+money=money |
cast( "{\\"currency\\":\\"EUR\\",\\"value\\": 3.14}" ; money)+2.71 | ERROR | Mismatching units |
cast( "{\\"currency\\":\\"EUR\\",\\"value\\": 3.14}" ; money)*2 | Money: {"currency":"EUR","value": 6.28} | money * integer = money |
cast( "{\\"currency\\":\\"EUR\\",\\"value\\": 3.14}" ; money) * cast( "{\\"currency\\":\\ "EUR\\",\\"value\\": 2.71}" ; money) | ERROR | What are the units of money squared |
cast( "{\\"currency\\":\\"EUR\\",\\"value\\": 3.14}" ; money)/ cast( "{\\"currency\\":\\ "EUR\\",\\"value\\": 1.56}" ; money) | 2 | money/money=double. WARNING: this does not check the currencies! |
cast( "{\\"currency\\":\\"EUR\\",\\"value\\": 3.14}" ; money)/2 | Money: {"currency":"EUR","value": 1.57} | money/double=money |
2 / cast( "{\\"currency\\":\\"EUR\\",\\"value\\": 3.14}" ; money) | ERROR | Inverse money does not exist |
| Template functions | ||
intVariable (integer@taskdatacache) + 3 | (addition) | Normal template functions like "case.attribute" can be used as an argument |
"abc intVariable (integer@taskdatacache)" | ERROR | Normal template functions cannot be used in a string |
"abc " & intVariable (integer@taskdatacache) | (string concatenation) | Use string concatenation instead |
function (string@taskdatacache) | (plain text) |