Hi guys,
My project is in the middle and i have some activities completed, mostly activities status is in progress. Some body help me on:
1) I want number of in progress activities that are ahead of the schedule.
2) Number of in progress activities that are behind the schedule.
3) Number of in progress activities that are on schedule.
Some one tell me the filter for above listed requirement
Hi Hafiz,
Also you can check, variance with BL finish dates. Activities with -ve values indicates behind schedule and those having +ve indicates ahead of schedule.
Best Regards,
Sunil.
sorry did it off the top of my head
here it is
then filter #1 activities ahead of ahead of schedule
ANY
where variance BL project start is less than start
or
where variance BL project finish is less than finish
filter #2 behind schedule
where variance BL project start is greater than start
or
where variance BL project finish if greater than finish
filter #3
where variance BL project start is equal to start
or
where variance BL project finish is equal to finish
Dear Zoltan,
Thx for your concern, but i check your method and "Variance BL Project Start" is not available in filters. Actually it is available in "parameters" but not under "value". Kindly further guid
1st add a column for number of activities its under number of activities then select activity count
then under group and sort check show group totals and show grand totals
you must maintain and assign a baseline
then filter #1 activities ahead of ahead of schedule
ANY
where start is less than variance BL project start
or
where finish is less than variance BL project finish
filter #2 behind schedule
where start is greater than variance BL project start
or
where finish is greater than variance BL project finish
filter #3
where start is equal to variance BL project start
or
where finish is equal to variance BL project finish
another way
filter #1
total float is greater than 0
filter #2
total float is less than 0
filter #3
total float equal 0
but I suspect you want the first set of parameters