Customer | Purchase Order | Amount | Shipping | Tax | Total |
C001 | P123 | 5.00 | 4.00 | 1.00 | 10.00 |
C001 | P126 | 5.00 | 4.00 | 1.00 | 10.00 |
C001 | P129 | 5.00 | 4.00 | 1.00 | 10.00 |
C002 | P124 | 5.00 | 4.00 | 1.00 | 10.00 |
C002 | P127 | 4.00 | 3.00 | 1.00 | 8.00 |
C002 | P130 | 6.00 | 5.00 | 1.00 | 12.00 |
C003 | P125 | 5.00 | 4.00 | 1.00 | 10.00 |
C003 | P128 | 7.00 | 6.00 | 1.00 | 14.00 |
I’m stuck on this issue and could use some assistance.
I have a list of customers, orders they have placed, and the amount of each order. I need to flag customers that have spent a total of 10 dollars or less on an order *only* if all the orders that customer has placed are 10 dollars or less. So in this case, customer C001 should be the only customer flagged.
Solved! Go to Solution.
Hey @kcfuiks, you can do this by looking at the average and max value for the Total. If, for each customer, the average total and the max total are less or equals to 10, then flag.
@atcodedog05 Thank you!
Happy to help : ) @kcfuiks
Cheers and have a nice day!