#1
|
|||
|
|||
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:
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")) |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
Quote:
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:
Can someone mark this as solved? Thanks again everyone! |
|
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 |
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 |