Forum Discussion
Helper ICalculating Status change with respect to date
Helper II don't know if there's an issue, but it wont let me paste my data as a table here. 😞
Memorable Memberits ok copy it to excel and share the excel file via dropbox or one drive or google drive link
- eliasayyy
ok im not sure if i got what you want correctly
is this the result? if yes let me know to share with you the necessary steps
- Khgo
no no, i need something different. let say, you have calculated this week steps and previous week steps. if you can create another column mentioning their difference with respect to date.
for ex: for batch xyz, we were at step no 4 on 26-08-2023 and today on 31-08-2023, it changed to step no. 5, so the new column should show the difference i.e. 1 (5-4 = 1) and that should be done on week level.
Could you also please not use sum cz it will complicate it a bit 🙂
sorry i asked for sum before 🙂
- Khgo
Please see if that works 🙂