If you have calculations that need to vary based on optional data, the left join method with isnull, case, etc. works well.