Distinguish RANK formula starting value

Options
KevinMcQuillen
KevinMcQuillen Member, ALL USERS, Certified Master Anaplanner, Certified Model Builder Posts: 5 Certified Master Anaplanner
in Planning & 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:

Categories