Hi Community ,
Can anyone help me describe how to use RANKCUMULATE function with an example ,
I understand the function syntax and all but I want to understand a use case of where this function can be used.
Thank you!
@Kanishq17
Ah yes, this is an awesome function. It's purpose is to cumulate the values that you are ranking. It's two functions in one. It first ranks your value and secondly accumulates the sales in the direction of the rank you choose. Let's say you want to rank your top stores and you want to know what % the top 10 stores make up in terms of sales. You can use Rank Cumulate. So, RANKCUMULATE(Sales, Sales) will rank the sales first, then cumulate the sales (ascendling by default). You can read more about this function here.
RANKCUMULATE - Anaplan Technical Documentation
Hi @JaredDolich
Really helpful ,
However can you explain with some screenshots as to how it works , so basically does the rank works first or cumulate?
It obviously has to RANK first, otherwise CUMULATE will work in an order in which the list items are arranged. So rank comes first and then it cumulates all the values corresponding to the ranks. This function is really helpful in Allocation.
Let us know if you still need more explanation.
Misbah
Miz Logix
Hi @Misbah
I understand , yes an example will really help , thanks a lot!
Hi Anaplanners, I’m working with a calculation module (Module A) that is dimensioned by a concatenated list, Time, and Native Versions. In this module, I am performing a subtraction using values from another module (Module B), which is dimensioned by Native Versions and a different concatenated list. The two concatenated…
I am trying to create a Net Debt / EBITDA formula at the bottom of one of our P&L income statements where, i have tried the MOVINGSUM function. However this does not work for summary line items which EBITDA is. What i would like is to be able to sum the previous 12 months EBITDA (Including the current period) numbers in a…
I have a selective access cost center list in a flat format that contains multiple hierarchy levels. I need to assign more than one cost center parent to a single user. While this can be done manually, I would like to know if there is a way to import this through a CSV file instead. Could you please confirm if this is…
