QUESTION: Formula that divides a field by the Sum of unique IDs within another field

[Czaggy]

Hello everyone,

I have the following table and want to calculate the Individual Task Work for every Resource - I do this by taking the total "Work Hours" for that ID and divide it by the number of resources with that Task ID. This should be replicated for all Tasks.

A task with only one resource should therefore have Work Hours = Task Work Individual.

Task ID	Resource Name	Work Hours	Task Work Individual	My desired Output
1	Maria	20	Work Hours / Count(Task ID)	5
1	Julia	20	Work Hours / Count(Task ID)	5
1	Peter	20	Work Hours / Count(Task ID)	5
1	Jeff	20	Work Hours / Count(Task ID)	5
2	Bob	30	Work Hours / Count(Task ID)	10
2	Amanda	30	Work Hours / Count(Task ID)	10
2	Rachel	30	Work Hours / Count(Task ID)	10

However I have troubles with the formula. I thought about using the multi-row-formula but I have never worked with that before.

Can anyone help me out?

Thank you in advance!

Kind regards,

Markus

[Jonathan-Sherman · Accepted solution]

Hi @Czaggy,

You could use a summarise tool to count the number of Task ID's, join this back and create a calculation to get your desired result:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan