Hello! My apologies in advance, but I seem to have lost my notes on how to "hide" a line item. Specifically, "Unit Price Growth % and Unit Cost Growth %" should be hidden. Thanks for your help!
Hello Community, I have the next list named BOM Lvl 1 List, with a Total Price Column, But, I need that if Semi-finish are TRUE, go to the list named BOM Lvl 2 List, and pull the price, adding up the …
In the 16 months from March 2020 to July 2021, business, government, and social organizations in the United States have faced unprecedented challenges to their very survival, as well as vast uncertain…
Hi Team, I am trying hard to calculate the number of parents for individual list items for unstructured list items. Kindly let me know in case of an optimized formula IF NAME(PARENT(ITEM(Region_Group)…
Activity 2.4.11 Testing Role Created Product Family Manager Role and then assigned myself this role. I did not make any change to Workspace Administrator. After testing, I changed my Role back to 'Ful…
Hi, question please. I am doing a workflow process approval that once the preparer/inputter submitted to the approver the input cell will automatically locked. Is it possible that the input cells will…
I am going backward to find an error in my model and was hoping someone might be able to give me direction. In my INV01 Module the Suggested Order Amount is coming out as 8,195 but in the training it …
As a model builder, I would like the ability to define the 'applies to' of a line item when creating and adding it to a module. This enhancement could work by enriching the current box for adding line…
Hello, I am trying to verify the model as part of 6.3. But the numbers are mismatching a little. Initial Account Sales Target from my build: Screenshot from the training material section 6.3 File rece…
Please can 'Is Summary' be disabled by default and require model builders to enable the setting. With the recent update to the blueprint view, this setting has become more hidden.
Are you transferring data between your models or do you want to transfer data between your models? If so, do take a look at our Cloudworks functionality. This article introduces the concept of the new…
Hello, I have created a module with multiple line items and values for FCST and Budget. I need to calculate the Variance which has a different formula for each line item. What is the best way to do th…
Hi, I need to calculate total loan interest for each month, and every loan was originated in different month. See below example, five loans were originated in different months and amount, and they hav…
Hi there My organisation's Anaplan model was originally built to cater for a "Bottom Up" sales plan , and I am amending it to also cater for a "Top Down" sales plan, when required. We have 2 modules i…
Hi , I'm trying to pull specific data based on the version selected by the user. I tried using Lookup and Select but didn't work. Any smart ways to fetch the specific values from the selected Version …
I have created the Country Made Line Item in SYS08 and the format is G2 Country List. In INV02 I created line item Safety Stock Flag Count and it's format is G2 Country List as well. But, I am getting…
Hi all, I need to import data from files provided by business. Since the files contain duplicates and i have to import all records so i am using numbered list for the import. But moving forward, I nee…
I want to calculate the amount by Weekday. This is the image. Module A ListDay2021/1/12021/1/22021/1/32021/1/42021/1/52021/1/62021/1/72021/1/8LineItemWeekdayMonTueWedThuFriSatSunMonLineItemAmountA100 …
Guys, I'm currently stuck on this particular use case, I have a module dimensioned by List A, it has its attributes as line items. Is there a way that i can sort the attributes in a custom format. The…
Hi Everyone, I'm trying to find a way for the following challenge: 1. There is a standard business case model for a supermarket that includes such lines as CAPEX, Revenue, Expenses, etc. The standard …
Hi There, I have completed/passed the sprint 1 exam however I could not get the answers for question 1 and 3. Could anyone please help me to understand where I was wrong and what are the correct answe…
Hi, Is there a way i can lock actual data when importing in Anaplan ? I have changed the version edit from and edit to but when i test the import, prior period are being updated by my load. Thanks in …
Hello Team, While working on Model Building course 1, i am stuck at Activity 9.2.6. The issue is, upto 9.2.5, every output is matching. But for 9.2.6, after making the changes, the final output is not…
Encountering an issue where the new ux is doing a full browser refresh. Not sure what is triggering this...but super annoying as it closes all tabs except the one I am currently in. I like the new UX …
Hi, I have a question about calculating the turnover rate. To calculate it, I use this formula. Formula: IF Inventory <= 0 THEN 0 ELSE IF Inventory <= MOVINGSUM(Demand, 1, 1) THEN 1 ELSE IF Inventory …
hi can you advise on level 2 sprint 2 2.3.9.1 Import data into DAT03 Historic Volumes module This process is failing with attached. Please can you advise. My source module is correct. thk u ravinder
Hello, I want to create a view which has numbers for multiple year first say 2018 to 2021 followed by yoy for each year. Currently i have created 2 different modules one for Numbers and other for year…
