ConditionalMax

This function returns maximal value from specified columns/fields in specified table/attachment, only looking in fields that satisify specified condition.

Syntax

ConditionalMax("source","fieldName","conditionalFieldName","conditionalValue");

Function arguments

• source – (String) The source of data containing values to be compared. This can be table name (i.e. 'Invoices’), nested table name (i.e. 'Finances>Invoices’) or an attachment template file name.
• fieldName – (String) The name of the column/field containing values to be compared.
• conditionalFieldName – (String) The name of the column/field containing value to be tested as condition.
• conditionalValue – (String) The value that conditional field value has to be equal to in order to satisfy condition

Return value

This function returns Decimal.
Returns the maximal value from specified column/field in specified table/attachment that satisfies specified conditon.

Examples

Example 1:
This will return maximal value of field 'column3′ in 'table1′ which 'column4′ value is equal to 'some value’.

ConditionalMax("table1", "column3", "column4", "some value");