Rank Formula - Excluding Blanks

RobinSilk
RobinSilk
in Modeling

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.

Tagged:

Best Answer

  • prabhu
    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).

     

     

    Capture.JPG

     

     

    Hope it helps 🙂

     

     

Answers

Categories