TOINTEGER

TOINTEGER(data);

This function can be used if you want to transfer data from a text field (date etc.) to an Integer.  It converts the value to INTEGER which ensures a correct comparison on lookup when e.g. transferring a field to a INTEGER field or if you need to calculate on the value.

 

Example 1:

##TOINTEGER(Points) > 15000,'Active','Inactive')

 

Example 2:

##TOINTEGER(Number) / 100