SUM_OF_ANY

Description

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 available

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

Example

SUM_OF_ANY(
p.income_from_employment,
p.income_from_wealth_gain,
p.other_income
)

This expression will add up the three types of personal income mentioned.

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.