I want to calculate the daily % of work done on my projects based on the Back Log reasons and the previous timestamp. Currently, the percentages are calculated by multiplying the number of request with the % of work that should be done at the given Backlog reason (outlined in the reference tab). Ideally the percentages of each project should add up to 100% once the Backlog reason "Close Complete" is used.
For example: Project #283, 45% was worked on 3/30 and 80% on the 3/31. The second day's percentage of work done should be 80% - 40% (from the previous time stamp) and the final day on the project should be 20% as listed as, "Closed Complete" is the Back Log reason that indicates that the project is done.
Is there a way to have a formula for the percentage, to subtract the percentage from the previous backlog reason and timestamp?
Hope you can help!
Thank you!
Bookmarks