Rank descending out of order

Brian123
Brian123
in Modeling

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?

Answers

  • jepley
    jepley
    image.png
    image.png

    Took a quick stab but unable to recreate your issue. See the above working as desired. Feel free to send me a message with a screenshot or an export of blueprint view.

Categories