Grouping: Task Percent Breakdown 1

In this custom project grouping, you can display projects grouped by a range of their percent complete values. The breakdowns show percent complete value of 25 percent point increments: 0-25%, 25-50%, etc. 

The following grouping organizes tasks by the percent complete value into one of six groupings:

  • 0%
  • 1-25%
  • 26-50%
  • 51-75%
  • 76-99%
  • 100%


To apply this grouping:

  1. Navigate to a list of tasks.
  2. From the Grouping drop-down menu, select New Grouping.
  3. Click Switch to Text Mode.
  4. Remove the text in the Group your Report area.
  5. Replace the text with the following code:
    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 %")))))
  6. Click Save Grouping.


This article last updated on 2018-06-25 14:13:20 UTC