F
frankod
Hi All,
I would like to be able to report via project server, at the project level,
on what percentage of tasks in the plan have a baseline saved. So far I have
sort of got it working, but its messy.
This is how I have worked so far.....
1) Created a field to count the total number of tasks using IIf([Baseline
Start]>0,"1","0") in a number field. This returns a value of 1 for every
tasks regardless of if it has a baseline or not - I know this is not very
elequant.. but it works. In addition I set the summary row roll up property
to sum. So at the 0 level task I have a count of how many tasks are in the
project.
2) Then I created a custom enterprise task field to test if each task has a
baseline using IIf([Baseline Finish]=ProjDateValue("NA"),"0","1") meaning
that if the task has a baseline the task receives a value of 1, if not 0,
again I set the summary row roll up propery to sum. So at the 0 level task I
have a count of how many baselined tasks are in the project.
3) Then I created a third custom number field to divide the result of point
2 above by the result of point 1 and then multipy by 100 - again at the 0
task level this gives me the right number for baselined tasks.
4) Finally I created a custom text field to display a "%" sign by using a
concatenate function [Number3] & " %"
My grand plan is to create a custom enterprise project field and pass up
this value, then add it to a project centre view and be able to quickly
identify projects that have less than 80% of their tasks baselined.
I have not done this yet because my method of getting the figure and adding
the % sign seems unnessarily messy, am I crazy?? There must be a cleaner
way?? Any suggestions appreciated.
Regards
Franko
I would like to be able to report via project server, at the project level,
on what percentage of tasks in the plan have a baseline saved. So far I have
sort of got it working, but its messy.
This is how I have worked so far.....
1) Created a field to count the total number of tasks using IIf([Baseline
Start]>0,"1","0") in a number field. This returns a value of 1 for every
tasks regardless of if it has a baseline or not - I know this is not very
elequant.. but it works. In addition I set the summary row roll up property
to sum. So at the 0 level task I have a count of how many tasks are in the
project.
2) Then I created a custom enterprise task field to test if each task has a
baseline using IIf([Baseline Finish]=ProjDateValue("NA"),"0","1") meaning
that if the task has a baseline the task receives a value of 1, if not 0,
again I set the summary row roll up propery to sum. So at the 0 level task I
have a count of how many baselined tasks are in the project.
3) Then I created a third custom number field to divide the result of point
2 above by the result of point 1 and then multipy by 100 - again at the 0
task level this gives me the right number for baselined tasks.
4) Finally I created a custom text field to display a "%" sign by using a
concatenate function [Number3] & " %"
My grand plan is to create a custom enterprise project field and pass up
this value, then add it to a project centre view and be able to quickly
identify projects that have less than 80% of their tasks baselined.
I have not done this yet because my method of getting the figure and adding
the % sign seems unnessarily messy, am I crazy?? There must be a cleaner
way?? Any suggestions appreciated.
Regards
Franko