Max

This function returns maximal value from specified columns/fields in specified table.

Syntax

Max("source","fieldName");

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’)
  • fieldName – (String) The name of the column/field containing decimal values from which maximal value is to be retrieved.

Return value

This function returns Decimal.
Returns maximal value from specified column/field in specified table.

Examples

Example 1:
This will return maximal value from 'column3′ in 'table1′.

Max("table1", "column3");
Was this article helpful?
0 out Of 5 Stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.