Hi Guys,
I need to deal a data which measure the work efficiency, that is compare the tasks finished everyday and all tasks open that day and from previous days' remaining.
So the calculation today will depend on that of yesterday cause I will include tasks haven't done before into TODAY's OPENING, I try to figure out the logic but I have no idea about looping it.
Please see attached workflow in which I try to show my logic. I am wondering is it possible to finish it inside an interactive macro? I tried but failed.
Really appreciate your time!
