Rank descending out of order
Sorry I don't have a screenshot for this. I think work is blocking the upload.
I have two RANK line items. I need one ascending and once descending.
This is the formula for the first one. It's ranking the five items that have the Include in Variance Rank? boolean 1-5.
RANK(Volume Weighted Variance Over Defined Months, ASCENDING, SEQUENTIAL, Include in Variance RANK?)
The next line item is exactly the same but I've changed ASCENDING to DESCENDING to reverse the order. However, instead of listing them 1-5 they're listed 3-7. Anyone got any idea what is happening here?
0