Rank sequential numbering and skipping certain criteria

Hello!

I am looking to create sequential numbering on employee numbered list within their respective cost centers but also looking to skip certain criteria such as TBHs. I am currently using RANK(1, ASCENDING, SEQUENTIAL, TRUE, LIST) which works well for numbering within the cost center but includes all members of the Employee (#) list. I would like to skip or ignore TBHs that are in the list. Below is an example of what I would like to see.

List - Employees (#)

Adam Smith 1

Jane Doe 2

TBH (skip)

Tom Miller 3

Any thoughts on how to get the sequential numbering to skip members of the list based on any number of attributes?

Thanks in advance!

Accepted answers

Nagaraju

Hi @chofacker

You have to control the "Include value" in Rank function. Instead of TRUE, create a line item to only include the non-TBH employees and refer it in the formula. See the approach below. Hope it helps!

All comments

Nagaraju

Hi @chofacker

You have to control the "Include value" in Rank function. Instead of TRUE, create a line item to only include the non-TBH employees and refer it in the formula. See the approach below. Hope it helps!

Quick Links

Can you help?

Unanswered questions

Set text encoding format for anaplan connect script upload
Hi, I would like to specify in an Anaplan Connect script that UTF-8 text encoding should be used for the file I am uploading. Does anyone know the command for this, or another way to make this happen? Thanks!
AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…