Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I am trying to rate my customers by points while:
| Online Pieces % | Pieces Total | Online Sales % | Sales Total | Points | |
| <=30% | <=50 | <=20% | <=20.000 | 4 | |
| >30% | >50 | >20% | >20.000 | 8 | |
| >40% | >100 | >40% | >40.000 | 12 | |
| >50% | >150 | >60% | >80.000 | 16 | |
| >60% | >300 | >80% | >200.000 | 20 | |
| >70% | >600 | - | - | 24 | |
| >80% | >1500 | - | - | 27 | |
| >90% | >3000 | - | - | 30 |
Each column shall increase the "Total Points" according to its result, while every column is checked once. So a customer can get between 16 and 100 Points.
I would be grateful for any idea that helps me add the result of column one and two at least.
Thank you! 
