SUM_OF_ANY
SUM_OF_ANY
is the flexible counterpart of SUM
.
It gives you the added total of the values you provide in between a set of brackets, each separated by a comma.If a value is not available:
SUM_OF_ANY
simply ignores it and gives you the total of values that are availableSUM
, before returning a result, will alert you to go back and provide the missing value.
p is Person
SUM_OF_ANY(
p.income_from_employment,
p.income_from_wealth_gain,
p.other_income
)
If the person in this case does not have any income from wealth gain, the outcome will be the total of the other two sources of income.
Last modified 1yr ago