In the formula field it is possible to use VBscript alike type of functions. There are some examples in our online manual and also in the Knowledge Base (see here) for the most commonly used functions such as Label(), In() and If(). A comprehensive list is attached below
| ++ | Increase value of variable | |
| -- | Decrease value of variable | |
| % | Make percentage (* 0.01) | |
| -@ | Negate the value (* -1) | |
| +@ | Make value positive | |
| ^ | Power | |
| ^@ | Integer power | |
| * | multiply | |
| / | division | |
| div | Integer division | |
| mod | modulus | |
| + | add | |
| - | substract | |
| > | Larger then comparison | |
| >= | Larger then or equal to comparison | |
| <= | Smaller then or equal to comparison | |
| < | Smaller then comparison | |
| <> | not equal to | |
| = | equal to | |
| in | is the first value in the list of other parameters e.g.: in(1, 3,4,5,6,7,8,1,2,9) returns 7, as the first value is found in the 7th position in the list of other parameters, if not found 0 is returned | |
| not | not binary operand | |
| or | or binary operand | |
| and | and binary operand | |
| xor | xor binary operand | |
| exp | the value of e raised to the power of x | |
| if | if x=True(or 1) then y else z | if(true, truevalue, falsevalue) |
| iif | if x=True(or 1) then y else z | iif(true, truevalue, falsevalue) |
| 'randg' | draw from normal distrib. (mean=x, sd =y) | |
| sqr | the square of a number (x*x) | |
| sqrt | the square root of a number | |
| abs | absolute value | |
| round | round to given number of digits | |
| trunc | truncates a real number to an integer | |
| ln | natural logarithm of x | |
| log10 | logarithm base 10 of | |
| logN | logarithm base x of y | |
| power | power: x^y | |
| pow | power: x^y | |
| intpower | power: x^y | |
| max | the maximum of both arguments | |
| min | the minimum of both arguments | |
| sin | sine of an angle in rad | |
| cos | cosine of an angle in rad | |
| tan | tangent of an angle in rad | |
| arcsin | inverse sine in rad | |
| arccos | inverse cosine in rad | |
| arctan2 | inverse tangent (x/y) in rad | |
| arctan | inverse tangent (x/y) in rad | |
| sinh | hyperbolic sine of an angle in rad | |
| cosh | hyperbolic sine of an angle in rad | |
| tanh | hyperbolic tangent of an angle in rad | |
| arcsinh | inverse sine in rad | |
| arccosh | inverse hyperbolic cosine in rad | |
| arctanh | inverse hyperbolic tangent in rad | |
| degtorad | conversion of degrees to radians | |
| radtodeg | conversion of rad to degrees | |
| textvalue | returns numeric value of text variable (e.g.: tekst value contains '3456' then that is returned as a value, if the text variable contains '3456T' system missing is returned | |
| label | Is the first parameter true return the second, third true then return 4th, Nth (oneven) is true return Nth even parameter | |
| notmissing | return the first value that is not sysmissing from the array of parameters | |
| avg | returns the average of the passed values | |
| IsNull | Equals spps null system missing | |
| IsNotNull | Not equals spps null system missing | |
| contains | Is the first parameter in the others (equals in function) | |
| choose | return the value, specified at the index given by the first parameter | |
| in | Is the first parameter in the others | |
| date_year | Get the year | |
| date_month | Get the month | |
| date_date | Get the day | |
| date_dayofweek | Get the day of the week as a number | |
| date_week | Get the week number | |
| date_hour | Get the hour | |
| date_minute | Get the minute | |
| date_second | Get the second | |
| now | Get the current date/time | |
| pos | Position in of substring in string e.g. pos('world', 'Hello world') returns 7 (position found) |