AnsweredAssumed Answered

Calculation- Diamond, Gold, Silver

Question asked by Kishan_Canoo on Oct 7, 2016
Latest reply on Oct 10, 2016 by dtcgnet

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