MIN

Description

MIN goes over all the values you provide. The values can be provided directly between the brackets, separated by commas or can come from a single list.

Example: Multiple values

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(
get_properties_from_instances(instances(AccountHolder), personal_income)),
0
)

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.

  • 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.