I have a field, ‘CRM Category’ (I.e. Diamond, Gold, Silver) for B2C End Customer – and another field for Total purchase over last 3 months – Calculation - If customer purchases for Rs 10,000 over last three months, a Diamond Customer, If customer purchases Rs5,000 over last three months, Gold customer. If customer purchases less than Rs5, 000, silver customer
My question is for the calculation of the Gold customer as for the Diamond i will use the grater symbol and for Silver the less symbol.
Case ( Total_Revenue < "10000" ; "Diamond")
Thank for your help