-
Line item with Month Format, need to repeat for all the period after it is calculated
Hello, I have a line item with Month Format (Maternities Month M_paid leaves calc) and need to repeat it until another line item with boolean format is true (Maternity). Tried with lastnonblank formula. Thank you for your help!
-
Is it possible to check capacity for each Module?
So I want to change my module. But I want to know how much capacity before and after implement new changes. Current now I only knew that we only can see the capacity for a whole model. Please someone, could you tell me about this information? Thank you!! 😄 BR, Dian Suci
-
3.3.6 Activity: Test the Shipping Cost Formulas
Hi! I followed all the steps carefully and answered correctly the questions (test your formulas) but now that I am replacing the offset with POST, I am not the getting any amount for "Confirmed Purchase Order Receipt" unlike in the should be amount. I don't know what's wrong with my formulas?
-
Subset-based display
Hello everyone, I have a module that is dimensioned by a store list. Each store belong to one or more comparison groups (each comparison group is a subset). I'd like to be able to select a comparison group and, depending on this selection, update the list of stores displayed. Do you know if ANAPLAN allows this? I hope my…
-
Technical documentation about Ananplan
Hi all, Does anybody know where to find Anaplan current documentation on the following points? EULA / SaaS Agreement / Terms of Use Data processing addendum/agreement Which Cloud provider hosts the infrastructure and where the data is stored (AWS, Google, Azure? Stored in the EU? Which country?) Backup/DR. How our data is…
-
No workspace admin, no access to UX page
Hi all, I'm currently facing a page visualization issue. The model has been set to have three kinds of page visualization: Full access, access to all the page, used by us anaplan consultants Corporate Role, access to all the pages, used by the managers User Role, access to some specific pages only More importantly, the…
-
Level 2 3.3.5.3 INV01 Inventory Ordering
Hi, I am struggling with figuring out where I went wrong with the INV 01 module. When checking my work, I'm all good up to Week 5, when the reorder flag isn't checked for me. I thought I did all the formulas right, and I'm stuck with where to look next. My work: Vs. what it should be: Can anyone help me understand where I…
-
How can I lookup a line item in a source module ?
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 and line items Source module: 13DL has a line item which has a list format of P Project Data ( derived from using Finditem…
-
Dimensions that don't exist yet
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 needed for this report. I know I can create the Regions but the only issue is that I do not have the data needed to input the…
-
Retrieving data from one store to Another
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 different stores : Now, the need is to merge the quantities of B01EUR and B03USD so that it becomes the quantities of B05USD.…
-
Stock Projection (Stock + Input - target)
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 if I input 1000 in Feb-24, I would have 146 + 1000 = 1146. I need to subtract the target for February, which is 261, from…
-
How to pull the annual total from the month forecast module?
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 item: expense Target module: Annual summary list: cost center & expense type Line item: expense, budget, variance, % NO TIME…
-
SELECT - two attributes
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) Sales module.Gross sales [SELECT: VERSIONS.Actual] and 2) Sales module.Gross sales [SELECT:Product.Nuts]. How do I write the…
-
Assigning List item based on Text line items and looking up - COMPLEX
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 one, also with Loan-Hedge ID (List) and line items as the dimensions. When importing the first file, these Loan-Hedge IDs…
-
How to divide a list item value by the total list items value ?
-
Having more than three dimensions in the pivoting of modules
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 the line items, but I am only able to add 2 categories, because the pivoting cannot exceed three dimensions in rows and…
-
Log of user activities
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 without user input. Our current design require imports. I'm wondering if anyone has done something similar without imports.…
-
Prior Year Value: Page selector?
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, I want to see the full year actuals of 2023. My current logic is only working for 2022 actuals. Actuals = Amount [Lookup:…
-
How to hide line items in UX avoiding repetitive hide UX command
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, responsible, employee name, labor cost line items only for the first project (1-Av-Bc - Argus V1); in short, I need to go…
-
How to clear dependent dropdown selection without error
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 changed Activity value to Activity B and forgot to change the related Project. But Project is still having value based on…