6 Replies Latest reply on Mar 10, 2016 1:54 AM by Tharashasank Davuluru

    How can I rank a table calculation result?

    Samuel Gee

      Hello!

       

      I have a database of products which drop their prices in a certain week.

       

      I have a calculated field which returns for each drop week a single % for the change in value going into the relevant week.

       

      I have a rank which is supposed to rank the %ages across drop weeks. So if drop week 1's value change is 42% and drop week 6's change is 28%, they'll receive a ranking of 2 and 1 respectively.

       

      My ranking wont work though. The rank value along each row should be the same (it changes), and the rank for the bottom rows disappears entirely.

       

      Can someone explain to me why?

       

      Many thanks indeed

       

      Sam