MAX_OF_ANY

Description

MAX_OF_ANY is the flexible counterpart of MAX.

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

If a value is not available:

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

• MAX, before returning a result, will alert you to go back and provide the missing value.

MAX_OF_ANY can also return the highest value of a list of values provided by another function.

Example

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

This expression will give you the value of the highest 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 higher value of the other two sources of income.