Conversion Functions

<< 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

FieldA

3.56700

 

DOUBLE([FieldA]) = 3.567

 

Example 2

FieldA

A.43

 

DOUBLE([FieldA]) = NULL

 

Example 3

FieldA

 

 

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

FieldA

3.567

 

INTEGER([FieldA]) = 4

 

Example 2

FieldA

A.43

 

INTEGER([FieldA]) = NULL

This formula is…

 

Example 3

FieldA

 

 

INTEGER([FieldA]) = 0