Forum Discussion
Difference between previous week and this week data
Hello, I have data as follows Date Sales Oct 4 - 36 Oct 11 - 30 Oct 18 - 25 Oct 25 - 20 I need the difference between this week and previous week data i.e Oct 25 - Oct 18 20 ...
Hello Ashish_Mathur
| Number | Balance | Date |
| 0 | 61625 | 10/20/2017 6:15 |
| 0 | 67219.92 | 10/15/2017 6:15 |
| 2.26 | 59320.41 | 10/10/2017 6:15 |
| 0.22 | 82904.55 | 10/25/2017 6:15 |
| 0 | 89217.92 | 10/18/2017 6:15 |
| 0 | 58800 | 10/19/2017 6:15 |
| 0 | 89868.48 | 10/20/2017 6:15 |
| -1 | 74000 | 10/15/2017 6:15 |
| 0 | 68400 | 10/20/2017 6:15 |
| 0 | 72450 | 10/2/2017 6:15 |
| 4 | 70300 | 10/11/2017 6:15 |
| 0 | 68400 | 10/12/2017 6:15 |
| 0 | 91383.16 | 10/18/2017 6:15 |
| 48 | 91575 | 10/14/2017 6:15 |
| 1 | 70775 | 10/22/2017 6:15 |
| -0.01 | 88788.74 | 10/14/2017 6:15 |
| -0.79 | 60823.19 | 10/8/2017 6:15 |
| 0 | 71225 | 10/13/2017 6:15 |
| 0 | 72150 | 10/11/2017 6:15 |
| 0 | 71250 | 10/21/2017 6:15 |
| 0 | 69837.5 | 10/10/2017 6:15 |
| 47.15 | 97570.8 | 10/12/2017 6:15 |
| 0 | 62400 | 10/25/2017 6:15 |
| 1 | 60450 | 10/26/2017 6:15 |
I am unable to attach the excel file.
Hi,
What is the use of the Number column? I thought you just want to add the Balance column on every Wednesday and then take the differrence over the previous week. Please show the actual result you are expecting based on the data that you pasted above.