Conditional hours Rollup

[ndiapro]

Hello there!
Could anybody help me please.
I want to get a total of spent hours per user per domain ?
A user can be related to many domains as well as a domain can be related to many users. So i need to rollup hours spent in a specific domain by a specific user so that a specific user could get seperate sum of hours spent for each domain he subscribe.

Thank you in advance for your help.

[Robert_Petitto]

Do other users need to see this rollup or only the signed in user?

[ndiapro]

Other users need to see this rollup. each user need to see their performances

[Darren_Murphy]

Asking Bob’s question in a different way…

If I am a user, and you are another user, should I be able to see the rollup of your data?
Or should I only see my own data?

Also, can you add a screen shot please that shows how the data is laid out. This will help to visualise the best solution.

[ndiapro]

Yes you should be able to see the rollup of my data.
As you can see on the screenshot. there are two challenges (it could be more than 2, as more challenges will be added).
I want to rollup for exemple N’DIA HERVE’S Total hours for the challenge “62 HEURES” and Total hours for the challenge “500 HEURES” seperately and all users could be able to see each other results.

Here is the result i have for the moment

This rollup show the total hours combining the 2 challenges.

[Darren_Murphy]

Okay, simple solution…

• Create a template column that joins the values in the Identifiant and Challenge columns in your PSC_Rapport table
• Create a multiple relation column that matches that template column to itself
• Now do your rollup through that relation

[ndiapro]

Thank you for your response but i have already use this trick and it does not work as i want. This method combines all challenges.

[Darren_Murphy]

It shouldn’t.

Can you show me how your relation column is configured please?

[ndiapro]

[Darren_Murphy]

Okay, that looks correct. Can I also see the configuration of your rollup column?

[ndiapro]

[Darren_Murphy]

Okay. Again, correct.

You say it isn’t working, but I think it is.
For example, I see a different value in row 4.

Now, I know you would expect the values in rows 1/2/3 to be different from the values in rows 5/6.

Two things could explain why they aren’t different:

• either both sets do actually sum to 685, or
• something is wrong with the template

So, one more screenshot please, of your template column configuration

[ndiapro]

The expecting results are
Line 1 : 120+150+165 = 435 hours for N’DIA HERVE’s performance in challenge 62 HEURES
Line 2 : same as line 1
Line 3 : same as line 1
Line 4: 150 hours for N’DIA SANDRINE’s performance in challenge 500 HEURES. And i think this is correct because she has not subscribe in more than one challenge
Line 5: 90+160 = 250 for N’DIA HERVE’s performance in challenge 500 HEURES

[Darren_Murphy]

Yes, there is the problem there - with your template.

Change it to something like this:

The way you have it now, it’s just returning the user name without the challenge, which explains the result that you are getting.

[ndiapro]

once more you solve the issue and i’am learning from you. THANKS A LOT DARREN.

here is the result