This content has been marked as final. Show 2 replies
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