Related( and default value if no match

[KevinShantz]

I am trying to use related( to replace lookup(. I believe my relationships are set properly as I get results using the formula workshop. However I am running into errors when there are no matching records in the database I am retrieving the data from. Is there an option to set a default value, 0 in my case, like there is in lookup( if no match is found? The documentation on related( makes reference to an option for “duplicate source key” but nothing for “missing source key” or "Default.

Using catcherror( does work to accomplish the goal, however it would be much smoother if there was an option right in related(. It seems every time I try to use it I am running into this problem. But maybe there is and I am just missing it.

[admin]

There is no default option. The catcherror( function is the correct way to handle this.

I’ve put a note in the issue tracker to possibly implement a “default” option. But this would be purely cosmetic - there would be no performance benefit to using such an option vs. the catcherror( function. Note that for several years the lookup( function has allowed you to leave off the default parameter, and use catcherror( instead.