Is there any 1 place that does all the rankings of formulas in terms of performance? The formulas I am trying to rank are…. Moving sum, YTD sum, cummulate, and timesum. In ranking fastest to slowest, …
What are the pieces of information that does not get copied to new model when copying a model by using the "Manage Models" screen and how does it compare with copying the model by revision tag When mo…
Hi Guys! I'm trying to build a formula where I basically need to check if two conditions are true. One of these conditions is to check if a certain text from a line item exists in a separate list that…
Hi Anyone who can help me with the formula for "Growth Rate %" line item? I put this formula ('DEM02 Volume Growth Rates by Week'.Growth %[LOOKUP: 'SYS08 SKU Details'.Product Family]) but I have zero …
Hi, Our model currently has the heirarchy sites > region > are, which is fed through our modules. One of our modules (visible through our UX's) give us price by site, where we can filter by region, bu…
Hello, I have a forecast module, with monthly TimeScale and I want to create, in this module, an option for a quarterly view. So basicly, if the client wants to see the data quarterly, he should be ab…
I have a use case to simplify let take an example. Assume we have product that can be bundled. Product A is single SKU. Product B is bundle of Product A plus some extra cost (eg packing cost). Product…
Hi, We currently have a line item (called driver), which is formatted as one of our lists. When a user goes into a UX, they currently have 15 options to choose from, however we want a specific one to …
Hi, I'm trying to SUM two line items in a model - currently we have the below which works: THEN '[SUM: 'PL 1. P&L '] …. As we want to SUM two line items in the module, we have tried the below (and oth…
I am looking for a way to lock a specific version so that numbers do not move for that specific version. I have used a version list in my modules instead of Anaplan's native version functionality. For…
I have a model which is of 500 gb in size and I have restored it to a previous version. How much time will it take? It is already 30 minutes since its running.
Looking to pull together values from multiple modules, which have started, as shown in the right hand screenshot. The difficulty I have is trying to pull the values across from a module such as INP08,…
OK. So we wrote a budget, had it approved and locked down as the Budget Version in Anaplan. A few months later we decided to move some of our assets around, with an impact on the budget. We would like…
Is there a way to apply a value to a certain list member and only the ones after, where a particular line item (where the adjustment was applied) is equal to? In my example, List members are shown in …
Question When one imports a dashboard, is the original dashboard in classic lost, or is it still available after the import? My preference is to have both and then, after tweaking, I can manually dele…