Aggregations

[#1]

Dear All,

I need to have below values on attached sample:

• Monthly base average point for each user,
• Monthly base average point for each Class group,
• Monthly base average point for each Duty group,
• Monthly base minimum average point for each Class group
• Monthly base maximum average point for each Class group
• Monthly base minimum average point for each Duty group
• Monthly base maximum average point for each Duty group

Thanks for your help.

Best Regards,

Asim Akin

[SunilChauhan]

see  the attached file

hope thiss helps you

[#3]

Hi Sunil,

I need to show all values in one table. Please check attached file.

Regards,

[perumal_41]

Hi,

see  the attached file

hope this file helps you

[#5]

Thanks Perumal,

But some of cells have null values. I want to see the values for each line and each cell. Would you please check again.

Kind Regards,

[#6]

hi, maybe u can use aggr(nodistinct .....)

C u,

Stefano.

[llauses243]

Hi,

This is my offer, pls to see image attach

Good luck, Luis

[perumal_41]

Hi,

see  the attached file

hope this file helps you

Regards,

Perumal

[#9]

Hi Luis,

I don't understand how can be the user 2 average lower than Class average for Haz.11? Would you please check attached image. The average of a person cannot be lower than class or duty minimum average. It may be equal but cannot be lower.

Would you please check your formulas again?

Kind Regards,

[llauses243 · Accepted solution]

Hi,

You tell me ... user 2 average lower than Class average for Haz.11?

for me is ok, pls to see image attached

Now respect to your image attached also adjust other image

Good luck, Luis