Exago Logo
Search
Generic filters
Exact matches only
Formulas and Functions

Custom Aggregate Function: AggDistinctSum()

Returns the sum of only unique values in a series.

Custom Aggregate Function: AggSumIf()

Returns the sum of values of dataToAggregate with a corresponding truecondition.

Custom Aggregate Function: ArgumentMax()

Returns the corresponding correspondingValue associated with the maximum value of maximizedValue.

Custom Aggregate Function: ArgumentMin()

Returns the corresponding correspondingValue associated with the minimum value of minimizedValue.

Arithmetic and Geometric Functions

Basic mathematical functions, as well as number field manipulation like truncation and rounding. Abs Description Returns the absolute value of a number. Remark   Example Abs(-23.1) – returns 23.1. Acos Description Returns the arccosine, or inverse cosine, of a ...