Editing a formula ---- Help

[Turki Ben Sumih]

dear Friends,

I have the following formula:

Switch(Len(CStr([Baseline Finish]))<3,"No
baseline",(Int(ProjDateDiff([Baseline Finish],[Finish])/[Baseline
Duration]*100))>=20,"Late 20% or more",(Int(ProjDateDiff([Baseline
Finish],[Finish])/[Baseline Duration]*100))>=10,"Late",True,"On schedule")

This formula gives me the schedual indicator for every project.
when i use the customized field(Containg the previous formula) to grouping
projects in PWA it gives me the the follwing result:

Late
Proj. 1
Proj. 3
Late 20% or more
Proj. 2
Proj. 5
On schedual
Proj. 4
Proj. 6

Dears, i dont want the previous sorting, i want it to be sorted as:

Late 20% or more THEN
Late THEN
On schedual

CAN any body help me solving this issue
thanks you in advance

 

[Brian K - Project MVP]

dear Friends,

I have the following formula:

Switch(Len(CStr([Baseline Finish]))<3,"No
baseline",(Int(ProjDateDiff([Baseline Finish],[Finish])/[Baseline
Duration]*100))>=20,"Late 20% or more",(Int(ProjDateDiff([Baseline
Finish],[Finish])/[Baseline Duration]*100))>=10,"Late",True,"On
schedule")

This formula gives me the schedual indicator for every project.
when i use the customized field(Containg the previous formula) to
grouping projects in PWA it gives me the the follwing result:

Late
Proj. 1
Proj. 3
Late 20% or more
Proj. 2
Proj. 5
On schedual
Proj. 4
Proj. 6

Dears, i dont want the previous sorting, i want it to be sorted as:

Late 20% or more THEN
Late THEN
On schedual

CAN any body help me solving this issue
thanks you in advance

It is an alpha sort so change the wording so that the results of the
formula are in the alpha order you want or put a 1, 2, 3 on the front.

 

[Turki Ben Sumih]

Dear Brian,
Thank you so much for your helping,
could you please help me numbering them because i'm not familiar the this
formula and formula in genenral.
thanks a lot
--
PMO Specialist

dear Friends,

I have the following formula:

Switch(Len(CStr([Baseline Finish]))<3,"No
baseline",(Int(ProjDateDiff([Baseline Finish],[Finish])/[Baseline
Duration]*100))>=20,"Late 20% or more",(Int(ProjDateDiff([Baseline
Finish],[Finish])/[Baseline Duration]*100))>=10,"Late",True,"On
schedule")

This formula gives me the schedual indicator for every project.
when i use the customized field(Containg the previous formula) to
grouping projects in PWA it gives me the the follwing result:

Late
Proj. 1
Proj. 3
Late 20% or more
Proj. 2
Proj. 5
On schedual
Proj. 4
Proj. 6

Dears, i dont want the previous sorting, i want it to be sorted as:

Late 20% or more THEN
Late THEN
On schedual

CAN any body help me solving this issue
thanks you in advance

It is an alpha sort so change the wording so that the results of the
formula are in the alpha order you want or put a 1, 2, 3 on the front.