Server Connect Join Collections

If I have 2 collections I join, but one does not have the matching field, no results display.

Is there a way to still have the resulting field show?

My aim is to then add values from each collection for the year as a total. So if Collection A has value($100) and Collection B does not have that year as a match, the results would be in a repeat quary adding them together:

$100 + 0 = $100

Currently I get no result because no join happens on the collection without the year.

Community Page
Last updated: