3 Replies Latest reply: Jul 31, 2012 10:20 AM by Celambarasan Adhimulam RSS

    Set Analysis Query

      Greetings All,

       

      Can anyone please tell me how to write this query to find the top customers by using rank():

      IF(Picking = 'Yes', COUNT(customer)/TotalOrder, COUNT(customer)/TotalOrder).

       

      Many Tx!