Group by project percent breakdown
To apply this grouping:
-
Go to a list of projects.
-
From the Grouping drop-down menu, select New Grouping.
-
Click Switch to Text Mode.
-
Remove the text in the box, and paste the following code in the available space:
group.0.linkedname=direct group.0.name=Percent Breakdown group.0.notime=false group.0.valueexpression=IF({percentComplete}=0,"0 %",IF({percentComplete}<=11,"1-10 %",IF({percentComplete}<=21,"11-20 %",IF({percentComplete}<=31,"21-30 %",IF({percentComplete}<41,"31-40 %",IF({percentComplete}<51,"41-50 %",IF({percentComplete}<61,"51-60 %",IF({percentComplete}<71,"61-70 %",IF({percentComplete}<81,"71-80 %",IF({percentComplete}<91,"81-90 %",IF({percentComplete}<100,"91-99 %","100 %"))))))))))) textmode=true
-
Click Done > Save Grouping.
-
(Optional) Update the name of the grouping, then click Save Grouping.