ok you are right then in this case you may have to export to excel and do the comparison there then tag each activity that increased with a code then import the code back into p6. Like I said the incremental percentages are a little harder to filter out.
However if the schedule is manhour loaded or cost loaded and you are performing a store period performance then you can filter where actual this period labor units or actual this period labor costs is greater than 0
Member for
11 years 3 months
Member for11 years4 months
Submitted by motunfolahan on Sat, 2015-03-07 08:56
It all went smoothly until the last filter(as below). The low value does not accept the syntax (UDF) old % complete- I tried all combination without luck. Please clarify.
filter any low value high value
where atual start is within the range DD-1W DD
or actual finish is wihtin the range DD-1W DD
or duration % complete is greater than (UDF) old % complete
Member for
16 years 3 months
Member for16 years4 months
Submitted by Zoltan Palffy on Fri, 2015-03-06 17:03
if you are talk about just the activites that have been progressed since last week you can easily get the activities that have started or finished getting the incremental % complete increase is a little more difficult.
filter any low value high value
where atual start is within the range DD-1W DD
or actual finish is wihtin the range DD-1W DD
or activity status equals in-progress
create a UDF (user defined filed) call it old % complete
take the previous update and export the new UDF filed and the duration % complete (or whatever type of % complete that you are using) to excel.
filter low value high value
where duration % complete is in the range of 1 99
now in excel copy the values in the duration % complete to the UDF column
when you get the update create the udf field again in the updated schedule and import the excel file that you just created into the updated schedule
now run a filter
filter any low value high value
where atual start is within the range DD-1W DD
or actual finish is wihtin the range DD-1W DD
or duration % complete is greater than (UDF) old % complete
Member for
16 years 3 monthsok you are right then in this
ok you are right then in this case you may have to export to excel and do the comparison there then tag each activity that increased with a code then import the code back into p6. Like I said the incremental percentages are a little harder to filter out.
However if the schedule is manhour loaded or cost loaded and you are performing a store period performance then you can filter where actual this period labor units or actual this period labor costs is greater than 0
Member for
11 years 3 monthsHi Zoltan, It all went
Hi Zoltan,
It all went smoothly until the last filter(as below). The low value does not accept the syntax (UDF) old % complete- I tried all combination without luck. Please clarify.
filter any low value high value
where atual start is within the range DD-1W DD
or actual finish is wihtin the range DD-1W DD
or duration % complete is greater than (UDF) old % complete
Member for
16 years 3 monthsI do what I can
I do what I can
Member for
11 years 3 monthsHi Zoltan,You are always in
Hi Zoltan,
You are always in high spirit to offer a help. Let me give your suggestion a shot and I will revert.
Thanks a lot.
Member for
16 years 3 monthsif you are talk about just
if you are talk about just the activites that have been progressed since last week you can easily get the activities that have started or finished getting the incremental % complete increase is a little more difficult.
filter any low value high value
where atual start is within the range DD-1W DD
or actual finish is wihtin the range DD-1W DD
or activity status equals in-progress
create a UDF (user defined filed) call it old % complete
take the previous update and export the new UDF filed and the duration % complete (or whatever type of % complete that you are using) to excel.
filter low value high value
where duration % complete is in the range of 1 99
now in excel copy the values in the duration % complete to the UDF column
when you get the update create the udf field again in the updated schedule and import the excel file that you just created into the updated schedule
now run a filter
filter any low value high value
where atual start is within the range DD-1W DD
or actual finish is wihtin the range DD-1W DD
or duration % complete is greater than (UDF) old % complete
do this for each update