2 Replies Latest reply: Feb 12, 2013 5:08 PM by Raj Vadde RSS

    Rank Functions

      I am attempting to use Rank in a straight table and it is not working correctly.

       

      This is an example of my two data tables

       

       

      Company NameMoney
      Company A10
      Company B20
      Company C45
      Company D15
      Company E25
      Company F

      30

       

      Group NameCompany Name
      Group 1Company A
      Group 1Company B
      Group 2Company C
      Group 3Company D
      Group 3Company E
      Group 3Company F

       

      So I then set up a straight table that looks like this

       

      Group NameMoneyRank
      Group 130-
      Group 2451
      Group 370-

      My Rank formula is rank(Money), it is only ranking the one group that only has one company under it. Is there a way to fix this?