Forum Discussion
RANKX Problem
I have been using the following formula with RANKX successfully with various tables, but I'm running into an issues where different values get the same rank with the following report: G - Rank = ...
Ok I managed to post the file on my One Drive:
https://1drv.ms/u/s!ArclD4PLnaKAnxHB4m7EAzuthu6e?e=QWP7ft
Please let me know what I might have overlooked that could explain this unintended behavior for RANKX.
Thanks, MT
Actually, please disregard the link posted in my last message as it appears to be a corrupted version of the report I created to illustrate the problem.
Instead, please use this link below to a ZIP file containing the report:
https://1drv.ms/u/s!ArclD4PLnaKAnxKraQDXUakCrlEb?e=7fa5lx
I created a few columns that also exhibit the unintended behavior of RANKX for non-zero values in columns.
Once again, any help appreciated.
Thanks, MT