Hi There, I am on a project where we have downloaded a model out of the model showcase, specifically the weekly stat engine. This assets provides a starting point for integrating statistical algorithm…
For example, if I have sales numbers w.r.t to time, however I want a single chart on front end that has a dropdown selection to switch between lets say 6 weeks, 6 months, 6 quarters as 3 options, how …
Description: To have an NPV formula function that calculates NPV exactly as Excel's period-based NPV formula does. Benefit/impact: Current NPV formula returns results as Excel's XNPV formula does (usi…
Hi everyone, Trying to get some ideas and best practices from this great community on how to clean up unused fields in Actions. I recently deleted some line items that I was no longer using. There was…
Is there a way to generate random numbers from a defined range of numbers so that the numbers being changed regularly in a module every time we refresh the model or just run an action?
Function that will generate random numbers, between specified min & max values. Excel has two functions to provide random numbers: RAND() generates a decimal value between 0 and 1 RANDBETWEEN( x , y )…
What is pre-allocation in lists? Pre-allocation in lists is a mechanism in Anaplan that adds a buffer to list lengths. It is not added by default for lists; it becomes enabled when a role is set on a …
Author: Hillary Sich is a Certified Master Anaplanner and Consultant Manager at Allitix. We use sticky notes, OneNote, Evernote…. Even if we can’t agree on the type of notes we use in everyday life, w…
Author: Anya Skvortsova is a Certified Master Anaplanner and CoE Lead at Asana. Purpose FP&A is often asked to calculate the impact of variables on the total variance. There is more than one way to go…
Hey everyone, I am hoping someone would be able to provide some clarification for me. I am on lesson 1.3.6 of Sprint 1 for Level 2 and it states that the following items need to be in the saved view. …
Hello Anaplanners, I have small query regarding size calculation, like how size of model is calculated using cell count of lineitem depending upon format used.. I would be better if I can get example …
1.4.6.1 Rename Actions Using the recommended naming conventions for Actions: * Rename the Actions used to load the P3 SKU list and SYS12 SKU Details system module:* Organize the Actions in the correct…
Hello all. A few days ago I saw a "How I Built It " video regarding the Hierarchy filter which taught me how to use Ratio Summary for filtering . I wanted to replicate the same structure but here is t…
Hello everyone , I have an old model with a time scale of 2023 and 2024 and after that I wanted to add 2025 in the time , some models take in consideration the next year , others not ! Is there any of…
Hi, I want to build a custom switchover for Fake version/List I created separately (Actual, Forecast, Rolling Forecast) I created a custom switchover time period 2. Then I created a custom switchover …
About the Author: Damien Bouquier has been a Certified Master Anaplanner for 5+ years and has developed solutions across a wide range of industries for FP&A, supply chain, and sales operations plannin…
I want to Copy a branch to another Parent. The hierarchy is 5 levels and i want to copy an item at level 3 and all its children to another item under level 2. All suggestions are appreciated!
Author: Kirill Kuznetsov is a Certified Master Anaplanner and Solution Architect at Planingo. Hi fellow Anaplanners, Today I would like to share six model building hacks I use on a daily basis. This i…
Could anyone who has finished the exam show me the formula for question 6? I failed 2 questions for this part. I think I just need to refer the relevant numbers from another module and apply selection…
I want to create an interactive anaplan module that allows user to select an item from a hierarchical list and dynamically display associated items from the next level in the hierarchy Lists : P1 Prod…
Hey Everyone, I'm trying to find a solution in an excel sheet that utilizes an iteration function that I need to replicate in Anaplan. Basically, we take the previous number multiply it by 90%, then t…
Hi. We will start a new project. In previous project, we made 1 model in 1 workspace. Off course, we have several models like (sand, test, Production model). It means we had several information in 1 m…
I am confused about what they are asking for in this section. The instructions say to Add DCA to INV01, which I did. But then there is a formula hint. I went back to Sprint 2 and rewatched the video f…
This is a detailed walk-through (and a downloadable link to a practice model!) that you can follow to get started on your UAM journey. Note that the examples here leverage the Bulk API for adding new …
I have condition in card where user can input negative value. But when the value is negative, the button will disable to click. I have data Product as Context Selector, Time Period Month in Column, an…
ello anaplan Community, Hello anaplan Support, we stumbled upon a problem that seems to us like a functional error of anaplan. Example Setup: List "List_A": * A * B * C * D * E List "List_B" * a* aa *…
