1 2 Previous Next 25 Replies Latest reply on Oct 10, 2016 10:20 AM by dtcgnet

    Calculation- Diamond, Gold, Silver


      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

        1 2 Previous Next