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.
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 🙂1
the "Y" parameter allows you to exclude a value: just create a boolean line item with your condition