Skip to content

Current period / this period, Progressed Activities, P6

Abbas IndiaMember for 17 years 3 months
Created
17
8
0
Dear All,

How to get / filter only the "this period" progressed activities in P6.

For example If I need to filter out the activities progressed during the current week/month etc..

Best regards,
Abbas

17 replies

Oldest first
  1. 0
    David Wallace ·
    Hi Abbas,

    I’ve noticed you’ve posted this twice, I’m assuming in error, do you mind if I delete the other posting?

    Thanks,

    David.
  2. 0
    Abbas India ·
    Hi,

    Sorry please delete it.

    thanks,
    Abbas
  3. 0
    Rohit Rangnekar ·
    Dear Abbas,

    There are not much people from india in this forum.

    Can we share our thoughts ?

    Regards,
  4. 0
    Hemanth Kumar ·
    There are several indians
    But not working in India
  5. 0
    Abbas India ·
    Dear All,

    Can you help me by providing a reply to my query.


    Thanks,
    Abbas.
  6. 0
    Ruel Camaquin ·
    Abbas,

    Maybe this could help,

    1. Add 1 column and id it as percentage complete
    2. Make a run date (current date is recommended)

    From there you will see this period % complete of your project. If this is not what you want to get, sorry for that.

    Cheers!

    Ruel
  7. 0
    Abbas India ·
    Hi Ruel,

    Thanks for your advise.

    Actually I need to get the this period gained progress that is Weekly or Monthly gained progress,

    NOT the cumulative figure.

    Can anybody give suggestion to my issue.

    Thanks,
    Abbas.
  8. 0
    A D ·
    U need to use Store Period Performance for this.

    I have not tried this in P6, but in P3, it works superb.

    Step I: After copying the program, Click on the Store Period Performance

    Step II: Define CDI called PLQT (Planned Qty this period)

    Step III: Then run a Global Change PLQT = BQWS

    Step IV: Update the program

    Step V: Run a Global Change T1 = BQWS - PLQT

    Step VI: Go to Tabular reports and then make ur custom report using following columns:
    BQ, BQWS, T1, QTP

    T1 is Planned Qty. This period; while QTP is Actual this Period.

    If u want, then u can add Variance Column too.

    I am not sure of weather this works in P6 or not (especially BQWS), but works very well for me in P3. I will try sometime today in P6 too and will inform u later.

    Cheers,

    Ravi
  9. 0
    Abbas India ·
    Hi Raviraj,

    Thanks,

    This is what I am looking for.

    But I am looking how this can be done through P6.

    Thanks,
    Abbas.
  10. 0
    A D ·
    OK,

    I will give a try this evening or by tomorrow in P6 and will let u know. Meanwhile, if u got anything, plz do fwd to us.

    Cheers,

    Ravi
  11. 0
    Arnold Puy ·
    Hi Abbas,

    In addition to Rav info. Try the following steps using P6.2

    1. Create a new BL1.
    2. The newly created BL1 must came from your last week update. Then assign the BL1 to your current project. This must be assigned into your Primary Baseline.
    3. When done, create a new filter (Activity Progress This Week) with the following parameters:

    - (All of the following)
    Where: BL1 Actual Start "equals" Blank
    And Physical % Complete "is greater than" 0%

    Note:
    1. Blank means no value at all. Leave the value blank.
    2. Physical % Complete, if you are using physical otherwise, Performance, Duration..etc...

    Just try these steps and let us know.

    Regards,

    Arnold


  12. 0
    Abbas India ·
    Dear Arnold,

    I tried the filter but it lists some of the current period activities but it missed some progressed activities.

    I think we have to do this using "Store Period Performance" as Mr. Ravi suggested. The thing is that it was working with P3 and how it can be done through P6.

    Please let us know if somebody knows about it.


    Best regards,
    Abbas.
  13. 0
    Duy Huynh ·
    HI Abbas,

    I am not sure how you define your "current period"?
    For example, based on Data Date, which one would you like to filter?

    - One week/month right before Data Date, start from Data Date minus one week/month to Data Date.
    - Or One week/month right after Data Date, start from Data Date plus one week/month forward.
    - Or, a period somewhere in the past of Data Date?
  14. 0
    A D ·
    It depends what and how u want?

    What u r always interested is measurement of progress between two reporting periods. This can be every week or every month or every fortnight and its minus from the data date of course....

    I have tried to do it in P6, but it seems it is somewhat difficult do get this report directly from P6.

    Cheers,

    Ravi
  15. 0
    Mohammed Ateeq Ur Rahman ·

    How to make filter for

    How to make filter for calculating positive gained progress means which is not supposed to start but started the activity

  16. 0
    Zoltan Palffy ·

    if you use stroe period

    if you use stroe period performance you can use \

    where cost this period is not equal to 0

    if you are updatng it monhly

    ANY

    where

    actaul start is with in the range of   DD-1M      DD        

    or

    actual finish is within the range of    DD-1m       DD

     

    th eonly thing missing then would be activities that were in progress and that that have had incremental progressed  during this reporting period.

    To get these you would have to  set the previous uddate as the baseline then create a udf and then run a global change to calculate the difference between the duration of physcial % complete q

  17. 0
    Nilesh Jain ·

    Hi,I'm trying to find the

    Hi,

    I'm trying to find the solution for the same question and after some research, the following are the steps that will help you to show % progressed for this period: (Make sure to copy the original schedule)

    1. Step1: Create UDF  say '1. Previous Month % Complete'

    2. Step 2: Create another UDH say ' 2. Progressed % for this period'

    3. Step 3: Global Change->New->Call it Previous month % Complete

    Then               Parameter                        Is              Parameter/Value             Operator               Parameter/Value

                   1. Previous Month % Complete     =           Duration% Complete

    Apply Changes->Commit Changes

    4. Step 4: Store Period Performance

    5. Step 3: Global Change->New-> Call it 'Progressed % for this period'

    Then               Parameter                    Is              Parameter/Value       Operator               Parameter/Value

           2. Progressed % for this month     =       Duration % Complete             -              1. Previous Month % Complete 

    6. Update the schedule 

    7. Run the global change created in step 5.

    Done!!

     

     

     

     

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?