Highlighted
Contributor

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.

2 REPLIES 2
Highlighted
Community Boss

Re: Rank Formula - Excluding Blanks

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

Nathan Rudman, Anaplan Model Builder
Highlighted
Super Contributor

Re: Rank Formula - Excluding Blanks

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 🙂

 

 

Sorna Raja Prabhu