SUM BY GROUP

[#1]

Hi,

Like a count group by category:

Count({< HoraireName = {'Journée'} >} TOTAL <DateProd, ligne> PersonneID)

is it possible to do a SUM?

By exemple:

If a want to have the sum of HPrest for each HoraireName, Ligne and DateProd where HoraireName is not equal "Journée"

I try this but it didn't work:

SUM({< HoraireName = HoraireName-{'Journée'} >} TOTAL <DateProd, ligne> Surface)

[Gysbert_Wassenaar · Accepted solution]

try: SUM({< HoraireName -= {'Journée'} >} TOTAL <DateProd, ligne> Surface)

[#3]

Thank you for your answer but it didn’t work.

Here is the result of your solution.

I think it SUM all data from database but not only the displayed value.

[Gysbert_Wassenaar]

In your screenshot you can see that the sum is grouped by DateProd and ligne and that the sum for Journée is 0. As far as I can see the expression does what you asked. If it's not correct you need to explain more. It would help if you could share the qvw file you're working on.

[#5]

Your are right J

During the time I ask my question and your answer I renamed one column (the cause of the error).

Thank you’re a lot for your quickly help.

Pierre

[chematos]

Ttry this:

Aggr() function is like a group by, you need to specify the grouping fields after the sum()

aggr(sum({< HoraireName -= {'Journée'} >} HPrest),HoraireName, Ligne, DateProd)

Regards