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