Follow
Grouping: Task Percent Breakdown 2

In this custom task grouping, you can display tasks grouped by a range of their percent complete values. The breakdowns show percent complete value of 10 percent point increments: 1-10%, 11-20%, etc. 

The following grouping organizes projects by the percent complete value into one of these groupings:

  • 0%
  • 1-10%
  • 11-20%
  • 21-30%
  • 31-40%
  • 41-50%
  • 51-60%
  • 61-70%
  • 71-80%
  • 81-90%
  • 91-99%
  • 100%

task_10__breakdown_grouping.png

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
    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
  6. Click Save Grouping.