Forum Discussion
Need Help with Summing Values
Anonymous
pls see the attachment below. Hope it's helpful.
still have a question. why the date for expected output is 2020/1/15 and 2020/1/16?
Anonymous
sry, still not clear about this. Could you pls provide some sample data, not the screenshot and also provide the expected output based on your sample data?
It will not let me post the tables for some reason. here is a link to the a file I created with Current Resutls, Expected Results, then Sample Data in that order.
Let me know if this works for you
https://drive.google.com/file/d/1OtKhdFohu8pSIIjRxbfgLm12OUjLppz9/view?usp=sharing
Anonymous
pls see the attachment below. Hope it's helpful.
still have a question. why the date for expected output is 2020/1/15 and 2020/1/16?
Sorry about that, it should have been april and august dates corressponding to the sample data. that was an error I made on accident when generating the file for you. This is exactly what I needed! thanks so much for the help and sorry for the confusion
you are welcome