MAX_OF_ANY
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 availableMAX
, 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.
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.
Last modified 1yr ago