Visual Studio (VSTS) parent fields average of children and calculated field

We have Features and Master Features work items. Master Features are parents of Features.

Both the Master Feature and the Feature have the same 3 fields that have values between 1 and 10.

Value to Business

Complexity to Build

Clarity of Requirements

We ONLY want to enter these values for Features, but have an average of these displayed for Master Features. For the Features we will input these manually (as shown). We would like the Master Feature for the child Features to have an average of the values of it's children (see attached diagram).

We also have a VCC column that is calculated from the 3 fields above.

VCC = [Value to Business] + [Clarity of Requirements] + 10 - [Complexity to Build]

For the Master Feature, the VCC value could EITHER be an average of it's childrens values, or calculated from the 3 fields of itself - which ever is easier.

We would like to be able to configure this functionality to hook up other fields or rename fields when needed or change the calculation for how VCC is calculated. Perhaps an XML/JSON configuration file.

My assumption is that it would be an Azure function (Node.js or C#) that reads the VSTS API and updates the values from a webhook. Your response should include instructions and your source code will need to be added to our VSTS instance.

Preference given to developers with good English, non-generic responses, explain their proposed solution (a few sentences is fine), and are available for daily 15-minute calls for the duration of the development between 9am and 10am UK time (we have other similar projects for Visual Studio, VSTS, that you could also potentially do).

PLEASE OUTLINE HOW YOU WOULD GO ABOUT IMPLEMENTING THIS SOLUTION TECHNICALLY.

Skills: .NET, Azure, C# Programming, RESTful, Software Architecture

See more: tfs work item calculated field, tfs query sum column, vsts completed work, tfs effort vs remaining work, tfs 2015 calculated field, vsts calculated field, tfs original estimate remaining completed, tfs work item rollup, please wait document processing crystal visual studio, create custom fields using visual studio 2008, custom fields sharepoint wss example visual studio, custom sharepoint fields visual studio, face recognition visual studio 2008, vb6 visual studio, visual studio 2008 flash, object oriented design visual studio, windows forms visual studio, exe decompiler visual studio, javame visual studio, windows visual studio 2008 windows form

Project ID: #16540510