Insert new row and calculate in a matrix

[aaumueller]

Hi there,

I'm currently trying to setup an overview of planned working hours by employee and project versus the standard hours. I get the data in the following format from the system:

Employee	Project	Week 1	Week 2	Week 3
Employee 1	Project 1	20	20	10
Employee 1	Project 2	20	30	20
Employee 1	Planned Hours	40	50	30
Employee 1	Standard Hours	40	40	40
Employee 2	Project 1	40	40	40
Employee 2	Project 2	0	10	0
Employee 2	Planned Hours	40	50	40
Employee 2	Standard Hours	40	40	40

I would like to add a row under each employee with the difference of Standard Hours to Planned Hours to identify overbookings in each week. So the result would look like this:

Employee	Project	Week 1	Week 2	Week 3
Employee 1	Project 1	20	20	10
Employee 1	Project 2	20	30	20
Employee 1	Planned Hours	40	50	30
Employee 1	Standard Hours	40	40	40
Employee 1	Difference	0	-10	10
Employee 2	Project 1	40	40	40
....

Any help highly appreciated 🙂

Regards

Alex

[fmvizcaino · Accepted solution]

Hi @aaumueller ,

Solution attached.

The Tile tool was used to generate a recordID and the sort tool to order as you need.

The parallel process was created to build your difference column. 

Best,

Fernando Vizcaino

[aaumueller]

Thanks so much fmvizcaino, works like a charm!