This content has been marked as final. Show 4 replies
I have a issue that I have not been able to find a work around for. I am trying to populate a text box with the rank of a sale person relative to the total sales person population. To do this I have been using AGGR with Rank in the formula below. This works fine until I filter by a product where the sales person has not sold anything. In those cases it is returning "-" in the text box. Ideally it would treat no sales as $0 sales and return the appropriate rank.
Any insight would be greatly appreciated.
Salesperson List Box
- Salesperson A