Rank Formula - Excluding Blanks


When looking at the page for the rank formula, there is a callout that says "Remember that if a source value is blank, the blank is ranked first for ascending order and last for descending order.". I am wondering how blanks could be excluded from a rank formula where I need to sequentially rank records based on when they are created in a list.

Best Answer

  • prabhu
    Answer ✓

    Hi @RobinSilk,


    For the Rank function, you can filter out values by providing conditions.


    1. See this example, I got ranked my Product based on values and i removed blank(0) by providing Condition(4th Attribute in Rank function).






    Hope it helps 🙂