Forum Discussion
Calculate Loss from various dates
Hi guys, I have a quick question. I want to calculate losses for 10 different stores from the date when they refurbished (all in last 12 weeks on different dates). I have Total loss figure for ever...
| Column1 | Store Number | Status | Completion Date |
| Project | 190 | Approved | 27/09/24 |
| Project | 259 | Approved | 27/09/24 |
| Project | 262 | Approved | 22/08/24 |
| Project | 301 | Approved | 11/10/24 |
| Project | 577 | Approved | 24/08/24 |
| Project | 602 | Approved | 01/11/24 |
| Project | 633 | Approved | 09/08/24 |
| Project | 633 | Approved | August |
| Project | 644 | Approved | 31/08/24 |
| Project | 836 | Approved | 23/08/24 |
| Project | 849 | Approved | 08/11/24 |
| Project | 917 | Approved | 04/10/24 |
| Project | 970 | Approved | 26/09/24 |
| Project | 1000 | Approved | 25/10/24 |
| Project | 1060 | Approved | 18/10/24 |
| Project | 1191 | Approved | 01/09/24 |
| Project | 1200 | Approved | 18/11/24 |