Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-03-2018, 03:26 AM
Loay harhash Loay harhash is offline Creating  2 percentage fields to show the progress from week to week Windows 10 Creating  2 percentage fields to show the progress from week to week Office 2013
Novice
Creating  2 percentage fields to show the progress from week to week
 
Join Date: Apr 2018
Posts: 1
Loay harhash is on a distinguished road
Question 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
Reply With Quote
Reply

Tags
custom fields, percentage, reporting

Thread Tools
Display Modes


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
Creating  2 percentage fields to show the progress from week to week Week by week report thedeadzeds Excel 3 11-16-2013 02:06 AM
Creating  2 percentage fields to show the progress from week to week 5 days/week during planning & 7 days/week during implementation sanlen Project 1 06-25-2012 04:17 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:37 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft