Skip to content

MAX

Description

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:

MAX(
    get_properties_from_instances(instances(AccountHolder), personal_income),
    0
)

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.
  • Adding 0 puts one more value into the comparison, so an empty list gives 0 rather than unknown. That reads as a default only because an income is never negative.
  • These four combined, give you the single highest value out of the personal incomes for all the accountholders in the case.

Empty and unknown values

An extra argument next to the list is not a fallback, it takes part in the calculation like any other value, so MAX([-5], 0) returns 0 rather than -5.

MAX returns unknown when the list is empty, and when any value in the list is unknown. The expression around it becomes unknown rather than failing, and a rule that needs the result asks for the missing value. Use MAX_OF_ANY to skip the unknown values instead, which returns 0 when nothing at all is known.