<< Click to Display Table of Contents >> Navigation:  Collect > Collect Enterprise > Template Designer Page > Formula Builder > Functions > Conversion Functions

The Conversion functions involve the process of changing a value from one data type to another data type. The functions are only able to compute integer and decimal data. Within EQuIS Collect, the functions perform calculations as data are entered in forms on the Mobile app. Within EQuIS Link, the functions provide a means to transform data when loading to a selected format.  

 

Below is a descriptive list of each function and its operations. The examples are applicable to either fields in a Collect form or an EQuIS Link data source, unless otherwise noted.

DOUBLE

The DOUBLE function converts a parameter into a decimal value. Returns a null value if the function cannot convert the parameter. The default value is 0 when no parameter is specified.

DOUBLE(<Parameter_1>)

Aggregate = No

 

Example 1

 

DOUBLE([FieldA]) = 3.567

 

Example 2

 

DOUBLE([FieldA]) = NULL

 

Example 3

 

DOUBLE([FieldA]) = 0

INTEGER

The INTEGER function converts a parameter into an integer value. Returns a null value if the function cannot convert the parameter. The default value is 0 when no parameter is specified. Rounds the value if it is a decimal.

INTEGER(<Parameter_1>)

Aggregate = No

 

Example 1

 

INTEGER([FieldA]) = 4

 

Example 2

 

INTEGER([FieldA]) = NULL

This formula is…

 

Example 3

 

INTEGER([FieldA]) = 0