ConditionalMin
This function returns minimal value from specified columns/fields in specified table/attachment, only looking in fields that satisify specified condition.
ConditionalMin("source","fieldName","conditionalFieldName","conditionalValue");Function arguments
Dział zatytułowany „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
Dział zatytułowany „Return value”This function returns Decimal. Returns the minimal value from specified column/field in specified table/attachment that satisfies specified conditon.
Examples
Dział zatytułowany „Examples”Example 1: This will return minimal value of field ’column3′ in ’table1′ which ’column4′ value is equal to ’some value’.
ConditionalMin("table1", "column3", "column4", "some value");