This one is more of a "stream of consciousness" workflow. I didn't plan it out, just started throwing tools on the canvas. Certainly not the recommended way of building out a workflow 🙂. I'm sure it could be tightened up quite a bit.
My solution is pretty similar to many others:
Since this was a pretty quick one, I decided to experiment with some slightly different configurations, to see if there were performance differences:
Next, I tried moving the Formula tool (to fill in the zeroes for the missing records) to the left output of the join only.