Calculating No. of Agencies/No. Compliant

Curtis — Mon, 23 Jan 2017 20:51:38 GMT

I have an individual systems list, on which are a column of divisions (Parks) and a column of 'compliant' systems.

I also have a program-wide list of compliant systems.

Is there a way to create, on the program-wide list, a column that auto-populates the 'number' of compliant systems from the individual list of systems - based on the Park they are locate.

Example: individual list may contain 10 line items of systems at 'ACME' park; 7 of those systems are compliant, 3 are not compliant.

The calculated column of the program-wide list, or the workflow, would need to automatically place a '7' in the program-wide list 'Compliant' column.

Workflow

Calculating No. of Agencies/No. Compliant