caculate field based on more variables

[Rense]

Hi,

I want to caculate for each order my total hours worked on it (this works already) an see a list of the activities and the hours spend on it.

In total the hours spend in activities have to add up to the total hours spend on the order.

To make it more clear I have a file attached.

test.zip

[Rense]

I've spend some more time on this problem and made some progress. I now have a portal that gives me the activities and the right calculation result from the hours spend in it but now the problem is that I want to see a activity once.

If an order has 3 records in it and record 1 has a number of hours for activity 1 and reord 2 and 3 have a number of hours for activity 2 my result will be:

activity 1 followed by a number of hours

activity 2 followed by a number of hours

activity 2 followed by a number of hours

and I would like it to be:

activity 1 followed by a number of hours

activity 2 followed by a number of hours

I've have attached an updated file.

test.zip