-
Did anyone faced this issue, why Anaplan is not allowing me to fetch Items using FINDITEM formula?
I have a list named Custom Weeks, and applied FINDITEM formula to get items against 'Next Start Date Text', but except Week 40 FY22 and Week 49 FY22, FINDITEM is not fetching items from the said list. Need help. Formula for 'Next Start Date Text' : TEXT(MONTH(Start Date + 7)) & "/" & TEXT(DAY(Start Date + 7)) & "/" &…
-
About deleting module data
Hello, I want to delete the module's data efficiently. With 100+ modules, manually removing them one by one would be too time consuming. Don't you know how to do something? Thank you
-
Using the same DEV for 3 different production models
Hello All, I use the same DEV model for three different production models that represent three different divisions at the company but pretty much the same design. Recently, I needed to add new developments to one of the models, but I do not want to push that functionality to other two models. Now, I need to make a new…
-
11.3.4 Activity: Add Formulas to Profit & Loss Report Module
Hi. requesting assistance in this part. I am not sure what I am doing wrong. I have transfer the file as directed but the number for forecast do not match. The data should be like this. Thank you
-
Line Item that keeps subtracting based on what's left
Hey, I would love to know if you can help me with this case. I'm trying to subtract the value of one Line Item from another depending on the result of the first one: For example, a projected stock value versus my financial target. It's easy in Excel, but I'm not sure how to perform this operation in Anaplan using a single…
-
How to deal with 3 dimensions having many to many relationship?
I am having some trouble connecting dimensions because I have a relationship with many-to-many and therefore I can not use LOOKUP as I am used to. I feel like I had some trouble explaining the problem before so I will use some screenshots. I have a model for a book retailer, and my final goal is to determine the…
-
Filter only those changed line items
Hello, I want to apply a filter to a module in order to import the new values re-writing the old ones. Let me explain a bit. I have a module dimensioned by Projects (a,b,c) This is my view of the grid in the first phase: Project Start Date End Date New Start Date New End Date A 15/8/2023 30/8/2015 B C Second Phase: Project…
-
"Fake Versions", vs. Native Versions. How do "Fake Versions" work and how do you set them up.
A lot of organisations seem to use "Fake Versions", vs. Native Versions. How do "Fake Versions" work. Please could someone explain how to set up and use "Fake Versions", How they should be used and of course how they work (the logic underpinning them). Thanks
-
Best practice for building a P&L with custom summary levels?
Hi, What is best practice for building out a P&L? The P&L applies to an existing list L2 GL accounts however, there are additional summary levels (ex. total travel) and calculations (gross margin, net income) that dont exist in the L2 GL account list but are required for the P&L report. See picture for example of…
-
Error message
Hello, I need help in creating a formula that divides the sales of a single week by the sales of the entire year. I am utilizing a custom calendar. When I attempt to use the SUM function, I encounter the following error message: "The name ' used in the SUM clause is not recognized as a line item in the model." I have…
-
Running multiple processes with one click?
Is it possible to run multiple process with single click and also be able to define the sequence of process. Similar to Actions
-
Can Anaplan Connect with batch scripts append data?
Hello, I'm using Anaplan Connect with batch scripts to integrate data into my Anaplan models. I'm interested in understanding whether Anaplan Connect supports the ability to append data to existing records in the models. Could you please provide information or guidance on achieving data appending using batch scripts in…
-
"Invalid name" error
Hi all When I try to import into a list I receive the error "invalid name". Do you know where I can find the explanation of this error? Thank you. Pic attached.
-
Importing Module with LIS into another Model without LIS
In this pivot image, "Plant Cost Category" is the LIS, and one of the Line Items here is called "Actuals From Staging". I want to import a saved view of this module into a different model but there are few issues: First, I only want the "Actuals From Staging" values in the new module but it appears to be aggregating across…
-
items number
Is there a limitation on the number of line items in a module?
-
Restore deleted native version
Hi - is there a way we can restore back a deleted native version? Thanks, Tom
-
Count within many to many relationship
Hi I am trying to solve below problem and was seeking help for an optimal way. I have a module which has a many to many relationship between Employees and Offices. I want a count of all unique employees within 1 office. For example in the below scenario, I have 3 offices with employees working from that office (1 employee…
-
Unable to see Docusign in usa1 Anaplan instance.
I'm using the same email address to login to both au1 and us1 Anaplan instances but I only see DocuSign in the dropdown option for au1 (refer to screenshots below). I have access to only one tenant in the au1 instances but have several tenants on the us1 instance. Is there a reason why? I also happen to be a tenant admin…
-
Is there any other method of enabling summarize function in anaplan?
Trying to figure out how to enable the summarize function. As the module does not have a time dimension changing it on blueprint view is not possible. I'm trying not to use the sum formula either. Can someone help me out and suggest any other way?
-
why are the values not rolling up to parent by default in attached photo