Modeling

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…
Publish Line Item as Page Selector to Dashboard
Hi team, Are you able to publish a Line Item from a module to a Dashboard as a Page selector that will act in the same manner as the dimensions published? e.g. the line item will change with the line item selected? Each time I attempt to 'Publish the Selected Line Items to Dashboard' the value of the line item is…
INVO1 SHIPPING TIME(WEEKS)
Hi, I am getting an error putting this formula to the shipping time(weeks). 'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product,LOOKUP:'SYS07 Distribution Center Details'.Default Shipping] error:Dimension of mapping used for lookup doesn't match any dimension of the result can…
3.5.4.2 Activity - Beginning Inventory Figures
The beginning inventory in this exercise seems off. I even checked other comments on the board and I have followed what I could. the second screenshot shows the set up for the INV01 Module for the beginning inventory line item. The formula is correct. but maybe something to do with the summary set up ?
Remove ability to edit Formula column on Line Items in Blueprint Mode
I've always been told as best practice to not edit formulas for line items directly in the formula column of blueprint view, instead to click on the line item and then activate the formula bar on the top of the page. However, we recently had a new model builder, who had not yet heard about this best practice, copy and…
Closing/Opening Balance Summary Method for Booleans
Simple request, please can closing balance and opening balance time summaries be made available to boolean formatted line items.
Combing 2 input values under one column
Hi, I would like to add up the 2 input values from "Sales" and "Marketing" into the new column called "Sales and Marketing". The reason is because there has been a change in the categories of business and the previously separated "Sales" and "Marketing" are now combined as one single category "Sales and Marketing". Is…
Time
Hi good day1 How can I make this as a row in a module? Because when I use time as a dimension, it aggregates the same date. Thank you.
Model to Model transfer action not working for full access user
Hi, I have created an import action from Model A to Model B and both are in same worksapce. Please see the below details of Model A & B. Model A: It is source model for an import action. I have used saved view for a module which is having User List as a dimension and with few line items. One line item is having their…
Copying Same Data Line Item to other Formulated Line Item
Dear All, I have a scenario as follows : I have a Module with SKU, Company as dimensions. Sales Volume is an input. List Items in Company are GST, TMB, BCC. Now, I want the data in line items to be copied to the company as follows: The output module should contain the input value as well as the copied data value. Thanks,…
Not able to rename Default Organization List
I was going through the training module and it says we can rename Organization List by double click on that, but I am double click is not resulting anything. How can I rename it.
Updating the data in Anaplan
Hi All, We are facing a challenge in Anaplan where user edits some data in anaplan but after some time there is a scenario that user might want to revert the changes back. Currently we are driving it will a boolean which user will confirm to update a row post that user will run an action which will populate the form which…
Create a report view based on its criteria
Hi Everyone, I have a question on how to do a linkage between 3 modules (Source Module, Mapping and Target) The image below is my mapping, basically, each Lane is connected to each Slottage Type based on each column. eg: if a lane is AA1AO "SC In - Consortium" should appear in the line item "Chartered In Exp - Initial…
Anaplan Documentation
Hi All, Please let me know if there is any documentation available to download as PDF or Word file. Thanks, Mahesh

Modeling

Discussion List