Distinguish RANK formula starting value

KevinMcQuillen
KevinMcQuillen
in Modeling

Hello,

I am wondering if there is functionality which would allow ranking based off of a specific starting value.

For example, I have 'Reference Line Item' = 3 (number formatted).

I then have my 'RANK Line Item' which includes my RANK formula.  

I would like the 'Rank Line Item' to start ranking from the Reference Line Item.  So the RANK formula would return 3, 4, 5, 6 for a specific group of 4 members, instead of returning 1, 2, 3, 4 for the same group of 4 members.

Is there a solution here, outside of using a separate line item which = 'RANK Line Item + Reference Line Item' (will not work due to dynamic needs of use-case)

Thanks!

 

Tagged:

Answers

  • M.Kierepka
    M.Kierepka

    Hi @KevinMcQuillen,

     

    I checked, and you can do it in the same line item (both with normal and grouped rank). So in your RANK line item, just add "+ Reference Line Item" at the end and it should work:

     

    =RANK(Source values [, Direction] [, Equal value behavior] [, Include value] [, Ranking groups]) + 'Reference Line Item'

Categories