Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-30-2015, 07:05 AM
Guloluseus Guloluseus is offline Planned % Complete not showing on summaries Windows 7 64bit Planned % Complete not showing on summaries Office 2010 32bit
Competent Performer
Planned % Complete not showing on summaries
 
Join Date: Mar 2013
Posts: 168
Guloluseus is on a distinguished road
Default Planned % Complete not showing on summaries

I have to use a Planned % Completion in programmes, with the (fairly) standard formula



Int(IIf([Status Date]>[Baseline Finish],100,IIf([Status Date]<[Baseline Start],0,ProjDateDiff([Baseline Start],[Status Date])/ProjDurValue([Baseline Duration])*100))) & "%"

This works fine for individual tasks, but does not give a %age for summaries. The exception to this is any works added after the baseline was set, which do give a percentage (of 0%, obviously).

I know there are other methods od calculating, but this is info that is filled in on a spreadsheet that then leads to graphs, pie charts etc to a standard format that is client required, so I cannot use EVM or any other alternative- it has to be planned % complete based on th eoriginla baseline.

Any help would be appreciated, and to clarify my worjk computer is tuning MSP10 standard.
The method of evaluation is client driven and has been mostly adopted by the company, so alternatives are not really an option.
Reply With Quote
  #2  
Old 11-30-2015, 05:11 PM
Guloluseus Guloluseus is offline Planned % Complete not showing on summaries Windows 7 64bit Planned % Complete not showing on summaries Office 2010 32bit
Competent Performer
Planned % Complete not showing on summaries
 
Join Date: Mar 2013
Posts: 168
Guloluseus is on a distinguished road
Default

Solved- forgot to tick a box in the formula page. Oops
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Planned % Complete not showing on summaries Showing how much work is required to complete a project according to summary task start/end times PDX-ADM-TRM01 Project 1 03-30-2015 04:05 PM
Planned % Complete not showing on summaries Creating a planned % column leeheps Project 4 07-15-2014 11:39 PM
Planned % Complete not showing on summaries physical complete %, regular work, vs % complete ketanco Project 1 06-16-2014 11:08 AM
% planned zahid Project 1 01-05-2012 06:37 PM
Show selected summaries and subtasks AndreT Project 0 01-14-2011 02:43 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:09 PM.


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