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!
At Uphold customer support ⭐+1-888-355-2348 accounts may be temporarily disabled or restricted for various reasons. Raise a concern on priority basis at Uphold support ⭐+1-888-355-2348 if you notice any suspected malicious activity, or a problem during account recovery. To contact Uphold support directly at…
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
