Dynamic ranking not working

ALKA

Hi Community,

I am trying to rank based on concatenation of two dimensions and rank doesn't seem to be working.

However, when I remove "group by" condition from rank formula, it ranks. Why is it so?

Can somebody explain please?

Thanks

Alka

Accepted answers

anikdas

Hi @ALKA

The group by column has different values for all the list items. That means there is only 1 item per group element. Hence, the rank becomes 1 for each of them.

Please revisit the grouping and it should work.

All comments

anikdas

Hi @ALKA

The group by column has different values for all the list items. That means there is only 1 item per group element. Hence, the rank becomes 1 for each of them.

Please revisit the grouping and it should work.

ALKA

Thanks for helping @anikdas , Understood!

Quick Links

Can you help?

Unanswered questions

Issue with Anaplan tab in Salesforce
I have installed the Anaplan app in Salesforce, but have been receiving an error. In the Anaplan part it asks for you to contact support, but does not provide any details into how to do this, just raising a ticket in the portal? WOuld be great to have more information.…
Data Integration to Fluence workspace
Hello Everyone, I am seeking guidance on how I could create a workflow process in Fluence consolidation workspace, using the ADO import task. Does anybody know what kind of information I need to fill in these fields? I have watched the ADO training but only explains the data transformation and integration within Anaplan…
Pagination in Management Reports Without splitting Parent Blocks
Hi I would like to set up pagination in management reports by assigning a page number to a list item and its parent but I also want to be able to keep a block of parent and list items together and not split over two pages. E.g. Parent 1 - 1 Child 1 - 2 Child 2 - 3 Parent 2 - 4 Child 3 - 5 Child 4 - 6 Child 5 - 7…