Create an aggregate with group By and Having field with a fixed value

[chou]

Hello, 

I want to do calculate the sum of MOPE having same NCRECRI and COPE= "DRB"

the variable DRB is a fixed value of DRB, that I have put it in the entry link.

but as a Result it doesn't take into account the cope = DRB, he is making the sum of all MOPE having same NCRECRI and COPE

Can you help me please? should I use another component?

[joearun4u · Accepted solution]

Hi @chou ,

Before passing the values into tAggregaterow, filter the values in tFilterrow i.e, COPE= "DRB". 

Try and raise your question if you still getting the same error.

Thanks,

Joe 

Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.