Rank Formula Work Around
I have a module dimensionalized by a list of unique identifiers that is the child of a Location list.
I'm trying to rank survey dates (a date formatted line item) in descending order based off of how recent they are BUT there are multiple UID's with the same survey date.
The problem is, with the "RANK" formula, the "Ties" and "Include" logic that is built into the formula can't be left out without the formula failing.
For example, the minimum, maximum, average, and sequential logic that has to be selected within the formula all don't work for me.
In the screenshot I've provided, you can see that the rank jumps from 4 to 29 because I have it set to "minimum" in the formula.
Ideally, I want this to display the number 5 rather than 29.
Does anyone have any ideas for a work around this?
Thanks so much!!