Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-30-2011, 09:16 AM
abw1987 abw1987 is offline Custom field formula not working at summary task level Windows 7 32bit Custom field formula not working at summary task level Office 2010 32bit
Novice
Custom field formula not working at summary task level
 
Join Date: Sep 2011
Location: Boston
Posts: 7
abw1987 is on a distinguished road
Default Custom field formula not working at summary task level

Hello,



I am having trouble getting a custom formula on a Text field to work at the summary task level.

Attached you will find an example Project Plan which contains the following fields:
  • Task Name/Duration/Start/Finish/Predecessors - these are obvious
  • % Complete (Planned) - this is just the % Complete field, automatically populated based on the Status Date of 10/12/11
  • % Complete (Actual) - this is a Text field with manually-entered percentages representing actual completion
  • Color - a visual representation comparing the Planned and Actual % Complete columns based on a custom formula. It's pretty straightforward, but the colors represent the following:
    • White: actual completion is marked 100%
    • Green: task has begun, and Actual completion is no more than 10% behind Planned completion
    • Yellow: task has begun, and Actual completion is between 10% and 20% behind Planned completion
    • Red: task has begun, and Actual completion is more than 20% behind Planned completion
    • Black: task has not yet begun
The problem is, you will notice no colored circle is appearing next to the summary task (row 1). If I remove the graphical indicators and just display the underlying value, still nothing appears in this row (i.e., I am not getting an error; there is just no value appearing).

Does anyone have an idea on how to get this formula to calculate for the summary task rows?

FYI - the formula I am using is below, though I doubt it matters:
Code:
IIf([Status Date]<[Start],"Black",IIf(val([Text2])<100,IIf(val([Text2])<([% Complete]-20),"RED",IIf(val([Text2])<([% Complete]-10),"YELLOW","GREEN")),"WHITE"))
Many thanks in advance.
Attached Files
File Type: zip ExampleProject.zip (24.4 KB, 23 views)
Reply With Quote
  #2  
Old 10-05-2011, 01:26 AM
seanpears99 seanpears99 is offline Custom field formula not working at summary task level Windows 7 64bit Custom field formula not working at summary task level Office 2007
Novice
 
Join Date: Oct 2011
Posts: 12
seanpears99 is on a distinguished road
Default

Hi ABW

I would advise against using calculations on summary fields as they are only containers for the items beneath them. Whenever I use customised fields I always leave the summaries alone.

If you wanted to display an indicator, go into the Graphical Indicator section and Click on Summary Rows and then summary rows inherit criteria from non summary rows.

Cheers
Sean
Reply With Quote
  #3  
Old 10-05-2011, 01:35 AM
seanpears99 seanpears99 is offline Custom field formula not working at summary task level Windows 7 64bit Custom field formula not working at summary task level Office 2007
Novice
 
Join Date: Oct 2011
Posts: 12
seanpears99 is on a distinguished road
Default

Hi ABW

Just to show you, if you apply your Actual Start to Complete Through against your summary, you will show green in your marker but you are actually behind schedule.

Also, in some instances, if you have too many nested summaries, MSP employs a weighting to each of the subsequent summaries so it further compounds your problem.

Hope this helps
Sean
Reply With Quote
  #4  
Old 10-05-2011, 07:17 AM
abw1987 abw1987 is offline Custom field formula not working at summary task level Windows 7 32bit Custom field formula not working at summary task level Office 2010 32bit
Novice
Custom field formula not working at summary task level
 
Join Date: Sep 2011
Location: Boston
Posts: 7
abw1987 is on a distinguished road
Default

Quote:
Originally Posted by seanpears99 View Post
Hi ABW

I would advise against using calculations on summary fields as they are only containers for the items beneath them. Whenever I use customised fields I always leave the summaries alone.

If you wanted to display an indicator, go into the Graphical Indicator section and Click on Summary Rows and then summary rows inherit criteria from non summary rows.

Cheers
Sean
Thanks Sean. This works perfectly. I'm actually embarrassed that I didn't figure this out myself, given that the options to do this were right there, exactly where one would expect.

I'm not too worried about using the calculation on summary fields, given that the formula only compares two numbers on each specific line, rather than having anything to do with the tasks beneath them. The calculation appears to function properly for now, but I'll be sure to keep my eyes open for any strange behavior.

Quote:
Originally Posted by seanpears99 View Post
Hi ABW

Just to show you, if you apply your Actual Start to Complete Through against your summary, you will show green in your marker but you are actually behind schedule.

Also, in some instances, if you have too many nested summaries, MSP employs a weighting to each of the subsequent summaries so it further compounds your problem.

Hope this helps
Sean
That is fine with me. I have the indicators set up to show green as long as the percentage is not more than 10% behind. You will notice that if the percentage on the summary task falls to, say, 15% behind, then the indicator turns yellow.



Can someone mark this as solved?

Thanks again everyone!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to subtract one month from due date field in reminder field ghumdinger Outlook 1 10-01-2011 12:09 AM
Custom field formula not working at summary task level Find summary level AndreT Project 2 08-05-2011 09:56 PM
Cannot Find a Task-timephased field OTPM Project 0 04-27-2011 05:27 AM
custom formula for duration ericfons Project 0 03-23-2010 01:18 PM
TOC Level 3 Field Not Showing Up (Word 2007) freitag Word 1 01-26-2010 08:47 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:24 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