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 alert you to go back and provide the missing valuIN

MIN_OF_ANY can also return the lowest value of a list of values provided by another function.

‚Äč

Example

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.