MS Project: Issues with Custom Equations

[jonathon.levin]

I am working in the Custom Fields section of MS Project. I am defining
a equation to measure whether tasks are Complete, More than 50%
complete, or less than 50% complete, by current day. I have set up
three custom "Number" equations;

Number 2: (([Finish]<[Current Date]) And ([% Complete]<50))
Number 3: (([Finish]<[Current Date]) And (([% Complete]>49) And ([%
Complete]<100)))
Number 4 (to bring them together so I can put a visual indicator into
the plan): [Number2] Or [Number3] Or ([% Work Complete]=100)


The problem is is that Project is showing the correct indicators like
it should, but ignoring the ([Finish]<[Current Date] part and thus
flagging tasks that are not yet due. Does anyone klnow what I am doing
wrong or how to fix it.


My other question is about master/subproject formula inheritance. IF
you put the formula in th emaster file, do you also need to insert it
to each sub project or does it get inserted automatically?

Thanks In Advance,
Jonathon

 

[Jack Dahlgren]

There are sometimes issues with custom fields which reference other custom
fields.
I'd rewrite your formula so it can do all of it in one calculation,
something like this:

iif([finish]<[current date],iif([%complete]<50, "return some value for
visual indicator",iif([%complete]<100,"return some other value","Task
complete)), "task not due")

If you are using this formula on project server then it will be available in
all projects.
If not, then there are some issues but you can test it and confirm.

-Jack Dahlgren