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