Activity ID NUBERS

when you combine a text with number, P6 treats the numbers as text, the "1" in A10000 is less than "9" in A9910. this applies to all the software,
the trick is to use a "0" always before the number.
2 is sorted AFTER 10
but
02 is sorted BEFORE 10

Ali,

Thank-you so much for answering that question, so what do i do now that i have a A9990 , to correct it for A10000. how can i fix this ? because i need it to go after A9990....

Hi Carlos,

Why don’t you try to add "0" right after "A" by using global change or maybe you can do one thing, instead of ascending use descending. But, the problem is all your activity id will be affected.

If you are interested with inserting 0 after A try this parameter in global change. But before doing this backup your project.

Where
Activity ID "does not contain" A1

Then
User_text1 "=" SubString(Activity ID,2,6)
Activity ID "=" A0 "&" User_text1

Just let me know, so that I can assist you.

Regards,

Arnold

Arnold,

Thanks a lot man i appreciate it i think i can get the global change done that should help i tiered to do the global change earlier but i had the wrong formula in there so i will try this and see how it goes..


thank you and have a merry christmas and a happy new year

Carlos,

Sometime, you don’t want to change the activity ID if the programme has already been submitted or approved.

If this isthe case, maybe sorting it by a custom data item will help.

Create a custom data item, assign value for every activity according to the intended order within the group (organization or WBS).

Yes, I agree, the best solution is to edit the activity ID.

Cheers

After A99990 use B00010

Nice one Mark, no-one saw that coming.