我们是否可以将Project“2010”中的关键任务计数作为项目级别的Project Server 2010中的自定义字段? [英] Can we get count of critical tasks of status 'late' as a custom field in Project Server 2010 at project level?
问题描述
大家好,
我们是否可以创建项目级自定义公式字段以获取计数状态'迟到'的关键任务 在Project Server 2010中?
请帮助
Can we create a project level custom formula field to get count of critical tasks of status 'late' in Project Server 2010 ?
Please help
谢谢,可爱
推荐答案
Hi Lovely,
Hi Lovely,
状态字段位于MS项目级别&报告数据库不包含该字段。我们可以使用公式计算任务状态&得到另一个过滤器,如下所示:
The status field is in MS project level & reporting database doesn't contain the field . We can have the formula to calculate the Task Status & get another filter as critical in below
Switch(
[%Complete] = 100,"Complete","
(([%Complete]< 100)And([完成]< Date())),"Overdue",zh
(([Baseline Start] = ProjDateValue(" NA"))或([Baseline Finish] = ProjD ateValue("NA"))),"No BL",
[完成差异]< = 0,"绿色",
[完成差异] < =(ProjDateDiff([Project Start],[Project Finish])* 0.1),"Yellow","
[Finish Variance]>(ProjDateDiff([Project Start],[Project Finish] ])* 0.1),"红色")
你可以阅读文章
http://www.projectserverhelp.com/Lists/Posts/Post.aspx?ID=27
http://www.projectserverhelp.com/Lists/Posts/Post.aspx?ID=27
H ope
有帮助。
这篇关于我们是否可以将Project“2010”中的关键任务计数作为项目级别的Project Server 2010中的自定义字段?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!