Server Connect Join Collections

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

Screenshot 2022-11-24 at 13.46.14862×612 31.2 KB

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.