Hi, I am trying to pull in a column data (Status) from a module 13DL into the target module 8R. LOOKUP didnt work for me. Help. What did I do wrong? Target module :8R is dimensioned by P Project Data …
I need to dimensionalize a report in Anaplan by Regions we currently don't use. They aren't in Anaplan at all. We have the accounts we need but the Regions in Anaplan are different that the Regions ne…
Hello everyone, I have one question regarding a dev I am currently working on. Here is the question : I have a line item that retrieves quantity from a file : Those quantities are splitted through dif…
If anyone can help me with this: I need to perform a stock simulation by inputting values, as you can see in Mar 24, I do not have enough to reach the Best Estimate (what I need is 261 to reach). But …
Much appreciate if someone can help with this one. Source module: monthly expense list: cost center & expense type Dimension: time (by month, with year total FY23); version (actual & forecast) Line it…
I try to write a function that selects both a specific version and a specific level in the hierarchy from a list. I know how to use the SELECT function individually on each of those selections: 1) Sal…
Hi Community, To give the backstory of this - I have a module, where I first import one data file into, with Loan-Hedge ID List) and line items as the dimensions. The second file I import is a similar…
Hello, Is there a way to have more than three dimensions as rows or columns when pivoting a module? Maybe it is easier with an example, I have to create a report that requires 3 categories on top of t…
Hi, We have a requirement in which details of changes need to be captured. For example, when user created a new request on Anaplan, we'd like to capture the user who created this request automatically…
How can I view the actuals for a previous year, regardless of the current year? For example, if if July 2023 is selected, I want to see the full year 2022 actuals. Similarly, if July 2024 is selected,…
Hi all, I am facing an issue I'm pretty sure many of you already have dealt with. The columns Cost Center, Responsible, Employee Name, Labor Cost are line items. I wish I could show the cost center, r…
Hi, I have created dependent drop down list line item. . See below example data entered by user. Activity is based on Project. Activity Project Activity A Project A Activity A Project A Later user cha…
Hi all, I am struggling a bit to find a way to add a new list item from a module. So, I have this module in which I let the user insert the product, the product code and finally the customer group; th…
Hi all, I am trying to find a way to calculate the Sales % of a items parent, and also of the Parent of the items parent. Below is an example of what I am trying to achieve,
Hello, I work at a company's headquarters, where we use Anaplan for reporting purposes. Some of these Anaplan models have been developed in-house, while others have been created by external consultant…
I have a formula which was written with the formula scope set to 'All Versions', then realised that I only need it to apply to 'Current Version', so I changed the scope but the data is still showing i…