Why is my RANK function changing result when I perform Bulk Copy Action?
In short, when I perform a Bulk Copy, my RANK function is changing and giving different result than what it should be.
I have a raw data source import file that is a listing containing all of our retail locations and their respective royalty rate that they pay us. The majority of the locations have one royalty rate for the entirety of their franchise agreement. However, there are locations that have “steps” in rate at various points in time. In sum, a salon could have 1 constant rate, or as many as 5 steps in rate over time. The import file has one column for location, one column for rate, and one column for start date. Thus, you have a many to 1 scenario where a location could be listed multiple times if there was more than one step.
My goal was to have Anaplan dynamically update the royalty rate schedule upon upload of the data source with no manual input to the source file.
In Anaplan the retail locations are a list.
I performed a RANK function by location over royalty step start date. If X location had 2 steps, the earlier date would be ranked 1, and the next date would be ranked 2. This worked as intended.
Rather than using the built-in VERSIONS, I use a list and create my own versions. I use “forecast” as my rolling/current version in my list. I archive my forecast monthly to a different list member like "Forecacst-April" via a Bulk Copy. I copy/archive so I can compare previous iterations of my model to the current Forecast.
When I performed the Bulk Copy to copy Forecast into Forecast -April, my RANK function for the step schedule changed. In the example given above, upon Bulk Copy, the X location would be ranked 1 and then 3. It should be 2 (vs 3) like when I originally built the formula/module.
As this is change is occurring during an Action like Bulk Copy, I am at a loss for how to troubleshoot. Any info much appreciated. Thanks!