Hi, I want to use Rank Function.
I want to rank "Num" with Location-Product.
I input formula into RANK Lineitem.
But the Rank function doesn't run.
What is the problem?
@hyudolee
I believe it is TIME dimension. Since every time member/item is considered to be a separate block logically it won't rank across blocks. To test this hypothesis you can get rid of Time dimension and use the same formula and see Rank working perfectly.
Since there are no duplicate time periods, it will consider every cell to be unique and rank every cell as 1. Remember One Whole List (Non Hierarchical) is considered to one block whereas in case of TIME and VERSIONS every Item of these is considered as one block. Hence rank works differently on TIME dimension.
Hope that helps
Misbah
MIZ LOGIX
To work around this you could map your Anaplan Time to a Fake Time List, perform the rank and then map back to Anaplan time.
Set up a list with items 1-n where n=number of periods in your timescale +1
Set up 2 mapping modules - 1 dimensioned by Anaplan Time and 1 by Fake Time. Have line items in those modules to pull in the appropriate mapping.
Set up a module with the same dimensions as above but replace Anaplan time with the Fake time list
Lookup the data you want to rank using your Fake Time -> Real-time mapping module
Calculate the RANK
Pass the rank info back to the Anaplan Time module using your Anaplan Time_Fake time lookup module.
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.…
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…
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…
