I have an action that imports data from excel into Anaplan. When the data fails to load, it is due to a missing list item (a project). When the items fail, I would like to extract the failure dump, an…
Both has same dimesion . now where ever the alternative the should be input by user and default is calculated based on then alternative i means . if alternatives have 20 and 30 the default should be 2…
Hello, I somehow struggle to find an answer to this problem: I have my line item "Sales" in Module 1, which is formatted with Dimensions A, B, C, D and Time (Year) and I want to aggregate these sales …
Hi, I am trying to replicate the Excel formula RATE in Anaplan. It seems to work for Q4, but not for the rest of the quarters. The excel formula is: =RATE(FRAC,,-$C$30,H30) where -C$30 is -100 and H30…
In source module i want to select the Defalult and alterenative is input. based on that target module percentage should calculate(if it is bdefault the 1(100% ) else balank) . now i am getting error m…
Hello I am trying do the the Model 1 Lesson 4 but I am stuck. 4.5.1. In the model you are building, click the Lists icon on the model settings bar to open the General Lists tab. This allows you to see…
Hello, I have a question in regards to manual entries in a schedule. I have a schedule below and for the three highlighted line items, users should be able to enter manual entries but they are not. Ca…
hello team members, I have attached a screenshot where I am getting error to restore my model. I have archived this model and copy archive. Does deployed mode cause any effect?
I have an interview upcoming and have been asked to created a Anaplan dashboard. I cant seem to find where to create one or any updated forums! I just want to know where I can go Anaplan itself, or An…
Hello, I'm loading flat data between 2 Anaplan models and in the target model, I'm using the Sum function to dimensionalize the flat data into a reporting module. The reporting module needs to have 5 …
Hi Everyone, I am working through a calculation where we are trying to determine the average age of our inventory backlog each day in time. We are using FIFO to determine what inventory is processed f…
Hello all, I want to change the rollups of Cost Center into its parent Division in hierarchy (i.e. Cost Center 100 belongs to Div 1 today. I want to change to Div 2). I can make teh change and write t…
Hello, I am trying to create a line item where I specify which product was sold the most by each of my sales reps. Rep and Product are lists on my model. I have a module called "Sales history" where I…
Hi everyone, I have a composite list which is set as production List in production model. It has 5 levels of hierarchy the 3 lower levels are numbered list. Due to customer request, changes need to be…
I have an issue with my Anaplan model. Revenue from companies within the same consolidation group are not eliminated properly. Can you help me troubleshoot this issue?
I want to migrate DBs to UX pages and in DBs there are Hierarchical DBs so to create UX pages for that Heirarchical list i have to create modules. so my question is when i am going to create module so…
I have a list type line item and its filter are Selective Access and Dependent. It is deployed on both tradition dashboard and NUX in same saved view. There are 3 available options(item) can be select…
Hi, I have 2 line item and on the other line item I used a Previous() function to try and get the last actuals value to spread it in forecast but it seems to not work, I also tried LAG() and same issu…
Hi, I need help here to get the associate last active plan as complan in one of the modules'. If I use current date in lookup its taking the compl plan as blank Thanks & Regards, Swapna
I have a module with PO numbers 1 line per PO, with space for 4 product codes The source list is from a simple PO list, with no details, i can then get the details of shipping etc using a lookup Inbou…