Modeling

Level 1 Model Building Exam Model Building Activity 6
I need a little help figuring out why I’m getting the the message pictured when entering my formulas.
Get Last data in all time
Hi, I use week General as Time setting. I want to get Last day in all time. Module A Time2021/1/12021/1/22021/1/32021/1/42021/1/52021/1/62021/1/7Num1111111Offset(Num,1,0)1111110Last day 2021/1/7 I can get last day in Module A. But I couldn't get in Module B( has no time, has Product List) Module B ProductLast…
SUM Function and List ALL
I want to aggregate the order From Table A to B. Table A RegionProductamountax100 y10bx200 y20 Table B Regionaggregatex300y30 I input the formula as below. Aggregate = Amount [SUM:Region] But I could not calculate it. If I have RegionALL as Region's top level of item, I could calculate it. We should use Top level of item…
how to use Lookup when source module has no dimensions.
My source module has no dimensions so How do I use lookup to transfer my data to result module. My Source file My Result module Data should onlu inserted in ABS not other two.
Exam Activities
Is there any way to get back on track. I think since I didn't get the right set up for the Activity 5, All of my answers have been wrong since even though I am adding new modules. Do I have to scrap the example? because I also made the mistake of having my model open and some things were built out in there by mistake.
8.2.2 Activity: Add Volume Inputs Module
Hello, I am getting this annoying error. I have looked up into community but haven't found any solution.
New Modelling Experience: New formula editor goes straight into edit mode
In the new modelling experience, when expanding the formula bar to display the whole formula in the new formula pane at the bottom of the screen it goes straight into 'edit' mode. This means that if you then click on another line item it adds '+[Line Item Name] onto the formula without you meaning to do so. Anaplan need to…
Which aggregate function is good at performance
Hi, I want to use aggregate function. I want to aggregate "Date" Lineitem from Order A&B to Aggregation Module. Date Lineitem has Date format. I use " OrderA.Date[Max:Product]" as Formula. And I can also use "Fristnonblank" and so on because Date Lineitem is common in module. Which Formula is good at performance? Each…
Summing data in a ragged hierarchy (just for reporting purposes)
Is there a way to sum data in a ragged hierarchy that will only be used for reporting? My source module is a Data Load module with all my GL transactions. The target module will be an output report dimensioned by a ragged hierarchy. I can get the data to sum on the lowest levels of the hierarchy but Anaplan does not seem…
comparing list items and changing value
Hi, In a module I had a list (A1,A2,A3,A4) and a line items Value,type(list formated line item),change value if two list items has same type and status as inactive then change value for inactive list item should get active list item value EX: valueTypeStatusChange…
SYS08 Employee Details Import Issue
Hello everyone, I am struggling to get it right. Could anyone help? Here are the snapshots. I have added all of the snapshots for your information.
Many to Many Sum in a single step?
I am in the middle of a model build and am running into a situation where I feel like there should be an efficient option to do a calculation, but I can't figure out a way to do it without a 'staging' line item that bloats the model. As the title says, I have a 'Many to Many' relationship - a single Deal can be tagged to…
Isolating Top Level Parent in a Boolean
I am having an issue that I'm not sure is able to be solved, but wanted to ask the community to see. I have a hierarchy as follows: Top Level = Total Company BU L1 parent = Total Company BU L2 parent = BU L1 In a boolean line item dimensioned by BU L2, I've tried a million ways to try and get the "Total Company" box to…
FINDITEM formula gives blanks whereas I expect values
Hi Anaplan Community, I have a strange behaviour in Anaplan. I use finditem in 4 different line items (Site 1, Site 2, Site 3 and Site 4) . The finditem formula is similar for each line item, it just refers to another text-formatted line item to perform the finditem. The result of the Site 1 formula looks good. However,…
indention and Summary using LIS
Hi Community, I would like to ask question, since I have not encountered this matter before. Below is a sample report with indention and Summary style. In this sample report, the items on the row are all Line items. For example the list below is a line item subset. Will I still be able to have indention if I am using an…
Holiday Time Filter
Hi, Trying to create a Line Item in my SYS Time Setting Module that filters out all of the Business Holidays that we are not operating. This is a Daily Model and not sure how to approach writing the Formula for this. I need to Eliminate the following Holidays (New Years Day, MLK Day, Memorial Day, Labor Day, Thanksgiving,…
Leve 2 Model Building Sprint 3
Hello all, I am stuck here for more than 4 hours trying to figure out why my numbers are different but unsuccessful. Can you please help advise? Mine: Anaplan's Much appreciated!! Daisy
Anaplan Roll up for Text Fields
Hello, Requirement :- The parent should have the average color of its children. I have an Indicator(Red , Yellow, Green) coming as a Text input from the Source. The requirement is to roll up to its immediate parent and its final parent subsequently based on the average color as per the children hierarchy. Kindly let me…
List Item Not Being Created
Hopefully someone can shed some light on why the following isn't working. I've a four dimensioned module that's used to create a numbered list under one of the four dimensions. To make further downstream calculations easier to manage and to improve sparsity only those items that have a value against them are being created.…
7.1.1 Data Import Methods
Hi Everyone, I am done with Lessons 1 - 6. I have just started Lesson 7 and I received the Notification of collaboration. I don't know with whom and how I can collaborate? I am lagging behind but I am catching up.
Publish Next Item Index
Is there a way to publish the Next Item Index from General Lists onto a App Page? Would be great for a Model Admin to be able to see when a List Index needs to be reset as it approaches the 1B mark.
11.3.4: Shipping costs Formula error
Hi, I need help for the formula error occurring in Shipping costs. Please find the screenshot for reference. Thank you Gourav
Level 1 EXAM ACTIVITY 2
I keep getting this same error message every time I enter a formula. I'm not sure if I'm entering the formula wrong, but can someone help me?
Model Search Feedback
New Model Search feature seems to start searching for matching items as long as you type the very first chararcter in the search bar. This is working fine on small models but on bigger models with lot of items (module, line item, list, etc.), this result in a freezing for up to 10s which can be disturbing. I'm used to…
New modelling experience
Hi Team, Few observations I have noticed will working on the models with New Modelling Experience: 1. We can't move the tabs in the order we want, like we were able to do in the classic view. Rearranging the Modules which are open. 2. Formula expansion I guess many of the Anaplanners have already raised that we can expand…
Decision Making Made Easy—Optimize Supply Chain Allocations Using Anaplan Optimizer
Global supply chains in the modern business world have become more complex, and a lack of supply chain visibility can affect profitability. It becomes even more challenging when supply chain managers have to make a decision and match supply-demand, considering constraints and profitability. When it comes to supply chain…
Previous on Custom Date
Hi Team, Assuming the Model's requirement is a monthly time dimension. However, the Cashflow Forecast requires input for every 7 days, or weekly set up. Is there a way for the previous date ending cash to be roll forwarded to the next date's beginning balance like this illustration below since I cannot use my previous, lag…
Model search extremely slow now in New Modeling Experience?
Ever since the the new items (line item subsets, etc.) were added to the model search recently, it's been extremely slow for me, with searches usually taking over 1 minute to complete. I'm curious if others are experiencing this or if it's just me/my instance. As it is now, it's basically unusable, which is a shame because…
List and Modules
is the "applies to" column within the modules view indicative of what lists are part of that module? Also, is there another way to tell what lists make up the modules?
Delete message in new UX
Hi, I tried run delete action in new UX. But there are no message, so I can't count how many items I deleted. I saw it in classic Dashboard.

Modeling

Discussion List