Set Analysis Query

[#1]

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!

[MayilVahanan]

HI

     Try like this,

     =Count({<Picking = {'Yes'} >} Customer) / TotalOrder

     Hope it helps

[#3]

Try like:

Count({Picking={'Yes'}>} customer)/TotalOrder

[CELAMBARASAN]

Hi,

First of all in your expression is if condition is needed?Both if and else part are same.

Can you explain little more breifer?