Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
HI
Try like this,
=Count({<Picking = {'Yes'} >} Customer) / TotalOrder
Hope it helps
Try like:
Count({Picking={'Yes'}>} customer)/TotalOrder
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?