MAX goes over all the values you provide in a set of brackets, each separated by a comma, and returns the highest value. It can also return the highest value from a single list produced by another function.

Example: Multiple values

e is Entity
MAX(e.expected_aum, e.actual_aum)

This expression will always return the value that is higher, whether that is the actual or the expected amount of assets under management for the entity.

Example: From single list of properties

MAX can also return the highest value of a list of values produced by another function. For example:

    get_properties_from_instances(instances(AccountHolder), personal_income),

This expression works in a couple of steps to bring you the result:

  • MAX( .... ) is the overarching function, of which you want the result. In between its brackets sits another function.

  • get_properties_from_instances(.......) is the function inside the MAX brackets, which goes and fetches the property of the instances you specify. For more information see also get_properties.

  • instances(AccountHolder, personal_income) returns the personal income of all the accountholders.

  • Since there could be no account holders, we add 0 as a default value to return.

  • These four combined, give you the single highest value out of the personal incomes for all the accountholders in the case.

Last updated