In this custom project grouping, you can display projects grouped by a range of their percent complete values.
The following grouping organizes projects by the percent complete value into one of these six groupings:
- 0%
- 1-25%
- 26-50%
- 51-75%
- 76-99%
- 100%
To apply this grouping:
- Navigate 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}<=26,"0-25 %",IF({percentComplete}<=51,"25-50 %",IF({percentComplete}<=76,"50-75 %",IF({percentComplete}<100,"75-99 %","100 %")))))
group.0.valueformat=string - Click Save Grouping.
Thank you for taking the time to provide feedback. We appreciate and value your contribution to our site. Feedback provided here is regularly reviewed by our Product Documentation team. Please ensure your comments are specific to improving this help article. Any questions or requests outside this help article content should be directed to our Community User Forum or by submitting a ticket to customer support.