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

Example: Multiple values

e is Entity
MIN(e.expected_aum, e.actual_aum)
This expression will always return the value that is lower, whether that is the actual or the expected amount of assets under management for the entity.

Example: From single list of properties

MIN can also return the lowest 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:
  • MIN(...) 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 MIN 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 lowest value out of the personal incomes for all the accountholders in the case.
Last modified 4mo ago
Copy link
On this page
Example: Multiple values
Example: From single list of properties