MIN_OF_ANY

Description

MIN_OF_ANY is the flexible counterpart of MIN.

It looks at all values you provide in between a set of brackets, each separated by a comma, and returns the lowest value.

If a value is not available:

• MIN_OF_ANY simply ignores it and gives you the highest out of values that are available

• MIN, before returning a result, will ask users to provide the missing value.

Example

p is Person
MIN_OF_ANY(
    p.income_from_employment, 
    p.income_from_wealth_gain, 
    p.other_income
)

This expression will give you the value of the lowest single type of personal income, out of the three types mentioned.

If the person in this case does not have any income from wealth gain, the outcome will be the lower value of the other two sources of income.