On Visual Studio Team System (VSTS), I understand that Remaining Work (Microsoft.VSTS.Scheduling.RemainingWork) should automatically roll up from tasks to PBIs (Product Backlog Items)/Bugs (of course if they're linked through Parent/Child link type). I created a new Process (from modified Scrum process), new project and assigned my new process to the new project I had created. So far so good.

When I create tasks either under a PBI or a Bug, the Remaining Work I enter in these tasks doesn't roll up to their parents (PBIs/Bugs). I compared the new template to an existing one (the existing one actually rolls everything up properly) and couldn't find any differences as far as this field (Microsoft.VSTS.Scheduling.RemainingWork) is concerned. Is there an additional setting that I need to check somewhere for the Roll-up to start happening?

I have Microsoft.VSTS.Scheduling.RemainingWork field defined in PBI, Bug and Task templates and all of them have Formula = 'sum'.

Below is the screengrab of the field's definition which is exactly the same for all 3 work item types (PBI/Bug/Task)

enter image description here


It does not roll up directly to data fields on the parent work item. Instead many of the Agile Planning Tool views show the roll up on a virtual field.

enter image description here

You can see ob the Backlog Item that the Remaining work has been rolled up for you. There are other views in relation to sprints where this happens.

If however you want to sum the work up you can, for TFS use the built in Data Warehouse to do the sum in a report, or in VSTS you can use the PowerBI Adapter for the same purpose.

  • 1
    Hi MrHinsh, yes you're right. It doesn't aggregate on the backlog board, but it does on the sprint board. Pretty weird why they do it this way, but it'll work. – Tony Feb 15 '17 at 15:43
  • I want it to aggregate on the Sprint Backlog, but there is no value on the Product Backlog. Is that what you mean? – MrHinsh - Martin Hinshelwood Feb 15 '17 at 16:45
  • I'd like to be able to aggregate on the product backlog too. But it's not a big deal. – Tony Feb 16 '17 at 17:44
  • 1
    You can request it on visualstudio.uservoice.com – MrHinsh - Martin Hinshelwood Feb 16 '17 at 19:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.