These functions provide tools that interpret numeric values. Many of these functions return information as an integer which can be further evaluated with mathematical operations.

Modifications to the extracted values are made for the purposes of the query only. The actual data stored in the target source is not changed in any way.


Function

Description

​ecx:formatNumber​

Formats a number based on the specified variables.

ecx:forceNumberParses numbers in a string attribute as an actual number. This function works in tandem with exc:formatNumber.

​ecm:round​

Rounds the target number up to a value determined by the specified number of fractional digits.

​Mathematical Operations (General)​

A full range of mathematical operations can be used in association with functions.

​ecm:max​

Returns the maximum value from the specified arguments.

​ecm:min​

Returns the minimum value from the specified arguments.

​ecm:avg​

Returns the average value from the specified arguments.

​ecx:distribute​

Generates a random result according to standard uniform distribution.

​ecm:random​

Returns a random positive integer between two integers.