5 Replies Latest reply: Sep 24, 2014 10:35 AM by Jon Vance RSS

    agg(rank(sum

      Hi,

      Using the agg rank sum formula, I was able to rank nine rows of data based on their 4 week growth.  But how is it possible that rank # 6 got skipped?  QV ended up with 10 ranks, skipping 6.  Just to check my sanity, I put the data in excel and using their rank function, it cam out correctly at 1 through 9.

       

      Any idea what is happening?

       

      Header 1Header 2Header 3Header 4
      region4 week growth4 week growth rankexcel rank formula
      120113133
      1202-5087
      120318522
      1204-2976
      1205-9198
      1206-153109
      120721411
      99802255
      99905644