I have a hopefully easy question.
I need to left outer join one table to the main table. I join them on two fields ID number and Location.
For example, for ID Number 9780553509755 my Forecast is correct 23183.52, however the issue comes with Actuals because I didn't join on them initially i get 9 repetitions of 1 instead of a just single 1.
The correct result is Forecast 23183.52 for all the time and 1 for Actuals for all the time (and not 9).
I cannot join Date and Date of Actuals because then I just get NULLs everywhere (they do not happen on the same date).
I think the desired result for me is to keep the same structure where FORECAST is broken down but actuals is getting summed only once without repetitions and either placed on a separate row or in just one of the rows anywhere where the forecast is provided.
Please let me know if someone may know how i can fix it.