Rank Formula - Excluding Blanks

RobinSilk

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.

prabhu

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 🙂

 

 

nathan_rudman

Hi,
https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/RANK.html
the "Y" parameter allows you to exclude a value: just create a boolean line item with your condition

ShubhamCh

@prabhu 

What's the significance of group by 2 here? I believe it'll give the same result even if it isn't included.