I want to calculate sum(sales) for each day. When I am calculaing this without any join i am getting the correct answer but after join with another two tables i am getting the values wrong. I have also tried it using fixed function but still i am getting the difference in values.
I have attached both sheets for your refernce i.e.
1. sales before join (Correct values of sales)
2. sales after join (Diffrence in values of sales)
I will require these joins for the further analytics.