0 Replies Latest reply on Oct 5, 2018 9:46 PM by Parag H

    Change in sum of column values after join

    Parag H

      Hi,

      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.

       

      Thanks,

      Parag