Hello

I have a situation with a formula that looks pretty simple to me but still doesn’t work.

We have customers that bought products.

These products belong to 3 different groups A, B and D

We want to know the amount paid by customers who bought 2 or more groups of products.

My work is described in the picture below

The formula 4 that feeds the last table, is similar to the formula 3. I just replaced the “number of customer codes” with the “sum of amounts”.

But BO doesn’t seem to like it and the result of the formula is not displayed… and I don’t understand why.

The number in the table 6 should be 21300,4. It is the sum displayed in the table 4 that shows the total Amount for the customers who bought 2 or more groups of products

There’s obviously something that I’m missing so if anybody can help, I would really appreciate it

Thank you

Alex