5 Replies Latest reply: Aug 26, 2016 10:38 AM by Vishwarath Nagaraju RSS

    Rank Closest to 100%

    Scott Springer

      I'm trying to figure out a way to rank based on a single expression that calculates a % and have it return rank = 1 to those that are closest to 100%.

       

      Here is a use case.  I have 3 employees that all budgeted an amount for expenses.  I want to rank them based on how accurate they were to their projected values.

       

      A = 105% to budget

      B = 100% to budget

      C = 98% to budget

       

      I would like the rank to display:

       

      B, 1

      C, 2

      A, 3

       

      Can anyone help?