0 Replies Latest reply on Jun 30, 2014 1:22 PM by Vinod Maharana

    Equivalent in Tableau for Excel function “percentrank”

    Vinod Maharana

      Has anyone tried simulating the Excel PERCENTRANK function in Tableau. I tried with this formula, but in many cases the calculation is off. I am sure there might be a better way to do it. If anyone has done, please share.

       

      (rank(sum([Debt/Cash %]), 'asc')-1) / (WINDOW_COUNT(sum([Debt/Cash %]))-1)

       

      Thanks

      Vinod