<< 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.
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
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
Copyright © 2022 EarthSoft, Inc • Modified: 02 Aug 2021