Distinguish RANK formula starting value
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)
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'1