Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

SUM is coming wrong

Hello Everyone, I am facing this issue where I am taking some csv sales files stored in a folder by using GET DATA>FOLDER.   But when I am collating combining the data of the csv files that are of...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

Anonymous Only thing I can think of is that one of the other files has data in it that is being classified as July. Hard to really say with the information provided.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hey Greg, 

    Thanks for responding. 

     

    Well yea I have two July files, one is of 2022 and other one is 2023 as shown in the below image. 

    If I am working with all of them it is not showing correct values but If I am working only "July 2023" then it is showing correct values