Conditional set analysis with Aggr function

[amber2000]

Hi everyone,

I would like to rewrite this statement to add a condition (it works fine):

=sum({$<[PC_Wrapping_Errors] = {"1"}>}Aggr(max([PC_Colli_Checked]),[PC_Ass]))

It's only working for those records who have value 1 in PC_Wrapping_Errors.

I would like to add the following (this is my pseudocode:

Sum (if (PC_Wrapping_Errors] = {"1"}

            then Aggr(max([PC_Colli_Checked]),[PC_Ass]))

                 Else Aggr(max([PC_Colli_Checked]),[PC_Pallet])))

Does anybody know how I can do this please?

I've tried this but it doesn't work:

//=if(PC_Wrapping_Errors > '1' ,Sum(Aggr(max([PC_Colli_Checked]),[PC_Ass])),

// if(PC_Wrapping_Errors < '0', Sum(Aggr(max([PC_Colli_Checked]),[PC_Pallet])))

kind regards,

Monique

[Anonymous · Accepted solution]

may be this

//=if(PC_Wrapping_Errors = '1' ,Sum(Aggr(max([PC_Colli_Checked]),[PC_Ass])), Sum(Aggr(max([PC_Colli_Checked]),[PC_Pallet])))

[amber2000]

Hi Allu,

It didn't work but after changing >1  into  >= 1 it worked fine.

Than you so much.

Kind regards,

Monique