Distinguish RANK formula starting value

KevinMcQuillen
Certified Master Anaplanner

Distinguish RANK formula starting value

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!

 

1 REPLY 1
M.Kierepka
Certified Master Anaplanner

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'