Modeling

Level 2 Sprint 2 Testing Role
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 'Full Access'. But now, I cannot access the Modules I created eg. DEM03 P3 SKU - no access, Accounts - no access. What went…
Workflow process approval
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 not be locked to the approver side once the preparer submitted it, which means that approver can edit the numbers in the…
INV01 Suggested Order Amount for the Month
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 shows 8,149. I have traced backward to DEM03 where my Final Forecast shows 8,194. Went back even further to try to figure it…
Ability to define line item 'applies to' when adding that line item to a module
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 items and allowing users to set the applies to at this point The benefit of this would be the ability to add line items…
Level 3; Sprint 1, Section 6.3
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 received from the training material and used for calculating the Initial Account Sales Target by Country and by Product Family.…
Disable 'Is Summary' by Default
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.
Easier Model to Model Data Transfer
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 Cloudworks features and functionality and including details of how to set up. Check it out. Remember: You can't plan…
Variance - calculation
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 this?
Cumulative interest calculation
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 have same interest % for each life period( i.e. loan x period 1 interest % is 1.058%, loan y period 1 interest % is also…
Using a IF THEN ELSE formula and LOOKUP formula to solve a Customer Buying Group mapping question
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 in this model, TOP DOWN and TOTAL SALES. TOP DOWN - Only has one Customer Buying Group code called "TDB" - short for Top Down…
Variance Analysis with dynamic version selection
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 dynamically? The table where User can select the Base or Compare Version - this is from the list items Trying to fetch data…
3.4.3 Create Country Module
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 the
Data Integration
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 need to import single unique keys and ignore the duplicates but retain their values. I am finding difficulty in accomplishing…
SUM Lineitems by Weekday
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 10 50 Module B ListWeekdayMonTueWedThuFriSatSunLineItemAmountB150(100+50) 10 I tried this formula but the Monday Total has…
Custom Sorting
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 native anaplan functionality gives A-Z or Z-A. I have an attribute with either items 'Important', 'Most important' &…
Level 2- Sprint 3-INV04 Distribution Center Capacity
Could someone help me with the formulas for these line items. 1.Distribution Center Capacity 2. Percentage full
Getting Sum of Line Item's Previous Values without Time Dimension
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 business case model doesn't have a specific launch month or data of launch for a supermarket as this is a business case for…
L2 MB Sprint 1 Exam Questions
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 answers? Regards,
3.3.12 Activity
Something does not look right with the filtering. I should not be seeing anything in the grid since the boxes are not checked, correct?
Lock Actual Data from Import
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 advance for helping. Regards, Tom
Values are not matching as per 9.2.6
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 matching.
New UX for Model Building is Browser Refreshing On its Own
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 would like ability to move the tabs around...I assuming that is coming. Browser Chrome Version 91.0.4472.124
How to calculate the turnover rate?
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 <= MOVINGSUM(Demand, 1, 2) THEN 2 ELSE IF Inventory <= MOVINGSUM(Demand, 1, 3) THEN 3・・・・ But this formula continues forever…
Performance Comparison - YEARVALUE(x) vs x[LOOKUP: FY]
Hi all, Was hoping to get some insight into the performance implications of obtaining the year value of a line using either YEARVALUE(x) or x[LOOKUP: FY]. Both will retrieve the same result assuming summaries/timescales are setup correctly, but they are definitely not calculated the same (based on anecdotal tests). From…
on demand - level 2 - sprint 2 - 2.3.9.1 Import data into DAT03 Historic Volumes module
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
Applying dimension one after the other (Year then Yoy %)
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 and used the view in UX, but it does not seen right. i have attached the screen shot of how i want vs how it is looking.…
Option for setting standard totals positions on rows
Totals position on rows defaults to "after" for each new module. Would be good if one can set the default on model level.
How to use FIRSTNONBLANK/LASTNONBLANK in a custom calendar
Hello everyone. I have created a custom calendar. I have mapped Week(List) and Year(List) corresponding to Time(Days). I would like to create a module that sets the start and end dates to the Week(List) and Year(List). I thought I could use the FIRSTNONBLANK and LASTNONBLANK function to get those dates, but it does not…
Adding of column values
Hi, I have a column which is made up from a List. I've created a "new column" called "Sales and Marketing" and would like to sum up the values that are currently in "Sales" and "Marketing" respectively. The values in the other columns remain as it is. Is there a formula that is able to do this? Structure of the module as…
total seems to be wrong
Hello Anaplanners The result of the calculation seems to be wrong. In fact is question 6 from model builder exam1. the formula should return the sum of expenses based on hierarchical level and region, However, in my result, I only get the total displayed, independent which selection is applied. I assume the the selection…

Modeling

Discussion List