Forum Discussion

pathomson's avatar
pathomson
Regular Visitor
8 years ago
Solved

RANKX Formula is missing a ranking number

I have several Rankings based off a single table of categories that is linked to other data tables. Some of my results show the ranking from 1 to 46, but others show 1 to 47 with a ranking number ski...
  • pathomson's avatar
    pathomson
    8 years ago

    Thanks,

     

    I have found the issue and the resolution throught trial and error.

    I had 5 different tables that I am ranking, and when they are joined, there are stations that are not in the master list of stations I want to rank by. To solve this issue, instead of the ALL function, I have changed it to ALLNONBLANKROW function.

    Now I am receiving the correct value of 46 as the highest instead of 47.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI afzalphatan,

 

If your table contains same values, rankx function will return same ranking value.

 

For Skip option, it will mark same value as same ranking, then marking next ranking as current ranking count.(e.g. 1,1,1,4,5,5,7,8...)

For Dense option, it will ranking values without skip same ranking number.(e.g. 1,1,1,2,3,3,4,5...)

 

Regards,
Xiaoxin Sheng

pathomson's avatar
pathomson
Regular Visitor
8 years ago

Thanks,

 

I have found the issue and the resolution throught trial and error.

I had 5 different tables that I am ranking, and when they are joined, there are stations that are not in the master list of stations I want to rank by. To solve this issue, instead of the ALL function, I have changed it to ALLNONBLANKROW function.

Now I am receiving the correct value of 46 as the highest instead of 47.