2 Replies Latest reply: Nov 26, 2012 6:21 AM by Stefan Wühl RSS

    Rank Help again

      Hi,

       

      I am continuing to struggle with a rank expression! I would like to rank agents based on the calls they have received  - this is the easy part. I only want to rank those that have received >0 calls and return that as a total (highest rank) in a column. My problem is that I can return the highest rank in a column but it is ranking the agents with 0 calls also which I want to avoid. In the attached example, I am looking to return on each row in the last column the value 14 which is the highest rank for those agents that had received >0 calls. I am currently getting 25 because it is ranking on the whole population which I want to avoid.

       

      Thanks in advance

       

      Haider