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)
Retrieving data ...