Grouping: Project Percent Breakdown 1

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:

  1. Navigate to a list of projects.
  2. From the Grouping drop-down menu, select New Grouping.
  3. Click Switch to Text Mode.
  4. Remove the text in the box, and paste the following code in the available space:
    group.0.linkedname=direct Breakdown
    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 %")))))
  5. Click Save Grouping.



This article last updated on 2018-06-25 14:12:41 UTC