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)