#1
|
|||
|
|||
Creating 2 percentage fields to show the progress from week to week
Hello Everyone,
I am in a middle of a dead end and would appreciate some help on this one please. To set the scene, I am looking after a MS Plan for a project where we normally send out weekly trackers to capture updates ( new dates, % complete changes, new tasks or deletion of existing ones). As a result of each tracker coming back, I update the Plan with all the new entries and changes. Following that I produce a change log which shows the current task name, current %age complete, last week's dates and this weeks changes, a field to flag if there was any change and what type of change it was. what I am trying to do is to show the difference in %age from week to week in the change log. i.e. a field to show last weeks percentage and a field to show this weeks % and I could think of 2 ways of doing so. 1. Manual Way - create 2 text fields to show this week and last week %age and show them on the change log by copy pasting every week (or embed in a macro) from last weeks to this weeks. the problem with this is if I update the original %age complete I have to copy it in this weeks %age, will be very manually made. 2. Thinking about creating a field which calculates the difference between 2 text fields in above solution. but don't know how to subtract 2 text fields that has %age in them? appreciate if anyone can help with an equation or some guide on how to show progress on %age from week to week HTD Thanks in Advance |
Tags |
custom fields, percentage, reporting |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
No.of Tasks by Resource by Week | j3griff | Project | 1 | 11-06-2017 01:34 PM |
4 Week Look Ahead | Eamon | Project | 0 | 05-29-2017 08:39 AM |
two week out notice | Normie | Project | 3 | 10-03-2016 08:16 AM |
Week by week report | thedeadzeds | Excel | 3 | 11-16-2013 02:06 AM |
5 days/week during planning & 7 days/week during implementation | sanlen | Project | 1 | 06-25-2012 04:17 PM |