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.

afzalphatan's avatar
afzalphatan
Icon for Resolver I rankResolver I
8 years ago

Just show the expected result for SMALL data set (pic in excel would be great) .... the logic will be same for any file size.....

pathomson's avatar
pathomson
Regular Visitor
8 years ago

Above is the current results. However, it shoud read 46, 45, 44.

Beow is the data table. However, the report page is filtered for the last 12 calendar months using a calendar table which is linked to this data table.

This data table is linked to the Ranking Station Table.

 

So there should be 3 stations that match for the last 12 calendar months, and the Ranking station table has 46 Stations.

Thus the Ranking should be 46, 45, 44 then all the remaining stations should be 1.