Translating % correct into a RANK()

Hello,

Question -

I have a module to calculate the percentage correct (e.g. 75%) and I want to be able to rank this on a scale of first to tenth place.

Advice on how to do that? I tried using the RANK() with the module calculating the percentage correct and could not get a solid translation.

Thanks in advance!

Accepted answers

JaredDolich

@JR1010

The RANK function is one of the coolest functions Anaplan has to offer in my opinion. However, there are a few nuances. Let's look at the function and input variables and try to figure out why you're not getting the desired result.

RANK(Source values [, Direction] [, Equal value behavior] [, Include value] [, Ranking groups])

The source value will be your "percentage correct" line item
Direction ranks up or down, I believe you want to rank down, so use DESCENDING
Equal value tells Anaplan what to do if more than one person has the same percentage correct. Lots of choices here, so take a look at the Anapedia link above.
Include value tells Anaplan if this should be ranked so use TRUE
Lastly, and probably where you're challenged, you can use a ranking group. A ranking group is a way for Anaplan to RANK within a group. So if you have multiple lists, say test number and class number, you may want to rank within those two. Create a group (see Anapedia to see how) that combines these together.

Good luck. You got this. RANK is one of the most powerful functions out there. Great that you're learning how to use it!

All comments

JaredDolich

@JR1010

RANK(Source values [, Direction] [, Equal value behavior] [, Include value] [, Ranking groups])

The source value will be your "percentage correct" line item
Direction ranks up or down, I believe you want to rank down, so use DESCENDING
Equal value tells Anaplan what to do if more than one person has the same percentage correct. Lots of choices here, so take a look at the Anapedia link above.
Include value tells Anaplan if this should be ranked so use TRUE
Lastly, and probably where you're challenged, you can use a ranking group. A ranking group is a way for Anaplan to RANK within a group. So if you have multiple lists, say test number and class number, you may want to rank within those two. Create a group (see Anapedia to see how) that combines these together.

Good luck. You got this. RANK is one of the most powerful functions out there. Great that you're learning how to use it!

JR1010

Created a group and that did it, thanks!

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…