Modeling

Adding a common line item associated with a single list item
Hello all, Can you please advice how to add "line item associated with a single list items"? In the attached screen shot, •MU approved/agreed and •GS approved are list items and I have created a nested dimension in module, such that the line item is common for these list items. Now I need to add, the columns highlighted in…
2.3.10 Activity: Create Demand Forecast- Need Help
I'm not getting any values for my 3 line items after the baseline forecast. I cannot figure out why this is happening. I see growth percentages in my source modules, but they are not being carried over in my formula for my "DEM03 Demand Forecast Module".
Create DEM04 Demand Export Module
Hello, please help me define the summary methods of Demand Export Module to match my results with the correct answer from the course. here si my results The correct result is attached
Help with formula using IF THEN ELSE statement with Versions
Hi, I'm trying to create a formula where the End User Input will flow to both the Forecast and Budget Version of my model. The formula I'm trying to use is below. I can get the End User Input to show in my Forecast Version, but not my Budget Version. Thank you
Card Configuration - Not able to check "Completed?" Box
Hello Community, In both DEV and PROD models, I have a "Completed?" checkbox that will be able to lock a schedule. In DEV, I'm able to mark the checkbox but in PROD, the box is grayed out. I've checked the settings in the NUX page and they both have the exact same settings toggled. Would anyone have any suggestions on how…
Sync from DEV to Debug
Hello Anaplan Community, I've made changes to a cell in the DEV model, and I'm trying to sync those changes from DEV to Debug. When I attempt to do so, I receive the following error (see attachment) and it doesn't sync that change. Has anyone experience this before and have any possible solutions?
TAR01 Detailed Sales Targets
I am struggling with LI "Initial Account Sales Target" any hint please. Also could be please confirm rest line item is as expected.
Level 2 - Sprint 3 - 3.3.7.2
Can anybody let me know if the below attached screenshot is right with regarding its format?
Help on 8.5.3 import data volume inputs module
Below Im trying to map everything out. Im currently trying to complete the activity. I looked over the instructions this is my screen shot : But I have Volumes on the other tab The product code is not showing as an option just saying the word column.... @Akhtar.shahbaz Please and thank you 😄
DEM 03 Baseline forecast formulas
Hi, I am trying to write formulas for this activity: Here is what I am doing: But the results are nor correct, How should I change the formulas and/or summary methods? Thanks
8.2.2 Add volume input modules
My dates are not showing. It is only showing Jan Instead of the training screenshot . Its suppose to look like below: @Akhtar.shahbaz @ryan_kohn Please and Thank you
Level 2 Model Building (Sprint 1) - Activity 1.3.3
In the level 2 - 1.3.3 activity, am i importing the files correctly? For example, when i import the county flat list, the directions tell me not to appoint a parent. So I proceeded per my screenshot below. is this correct?
Put a condition in a lookup
Input: ABCDEFranceGermanySpainPortugalSweden Calculate : BCDEOrigin countryFrance (A)Germany (B)Spain (C)Portugal (D)Actual CountryGermany (B)Spain (C)Portugal (D)Sweden Hello, I would like to know if you can help me with the formula for "Origin Country". It is supposed to send me the information from the previous step to…
Boolean Selection
Hi, Is there a way where I can manipulate the boolean checked by the user and automatically selects as well the other selection? For this example, if a user selects Forecast-Aug, it will deselect the highlighted items for Plan, Actual CY and Actual PY as well. We don't want users to do multiple selection just to cover the…
Lesson 9.2.5
Hi all, I am trying to input the formula in unit price % in rev05. I am getting the error "Dimension of mapping used for lookup doesn't match any dimension of the result". However, when I input the formula in unit cost % in rev05 it works just fine. I have went back to look at SYS04 and SYS06 formats/formulas and haven't…
issue in populating data
Hi Members , I am still facing an issue where in I have to populate FY WEEK 20 forecast with the Actual volumes of FY WEEK 19 ( ALL weeks ) I have used the below mentioned formulae IF 'SYS01 Time Settings By Week'.Current Period? THEN 'DAT03 Historic Volumes'.Volumes ELSE 0 Also used IF 'SYS01 Time Settings By…
Level 1 Activity 5
Getting an error for dimension of mapping used for lookup doesn't match any dimension of the result.
3.3.6 Activity: Test the Shipping Cost Formulas
The Final Shipping Time Weeks is right? Why is it not 1 in my module?
Further help, with what should be a simple lookup
Hi, I have a ranking module as below This shows the top customers and some data changes ranked, also there is an image for each customer Now I have a module where I need to store the top 5 customers images to feed a business report A simple lookup in Excel, looking up 1 ,2,3,4,5 etc but for the life of me i can't figure…
Fetching Start Month and End Month for a given Quarter
Hi all, I'm trying to fetch Start Month of a Quarter input by the User. I created a line item for input by the user formatted as Time Period Quarter and another Line item formatted as Month. I tried multiple ways and looking for help to fetch Start Month (say for selection of Q1 FY20 - looking to fetch JAN 20 similarly for…
Level 1 4.6.6 Activity: Import Data into P1 Product Family List.
Hi you amazing community 🙂 When I import the data for P1 list and map it, I either get an error that family name doesn't exist (chocolates doesn't exist), or CH maps under chocolate, etc. There's also no option for parent mapping. My grid doesn't look like the training instructions and I'm stuck. Thanks so much in advance
3.3.5.3 Check Your Work
The method and Shipping Time weeks are not getting populated in my module. I don't know why? Help me resolve this?
Rank using Unique Item
Hi, I have a module which shows change in volumes by Customer - Product (over 5000 lines) I then rank these changes largest to smallest, and have a view of that. Customer ProductLast MonthCurrent MonthChangeRankCustomer A - Product 1340,480311,576-28,9051Customer A - Product 270,32646,326-24,0002Customer D - Product…
Level 2 - Sprint 3 - 3.3.5.2
Let me know, if what I did is right or not Create a Filter You will need to create two Boolean-formatted line items in the SYS01 Time Settings by Week systems module: * Line Item Name: First Week of Timescale? * Use this Boolean-formatted line item to select the first week of the timescale. * End users can manually select…
Level 2 - Sprint 3 - 3.3.5.2
Can I get help regarding this? This line item needs to display the value from the Beginning Inventory line item in DAT01 Beginning Inventory module for the first week of the year and the Ending Inventory from the previous week. The syntax of the formula should be written: If it is not the first week of the year, then use…
Weekly subtotals for model with calendar type M/Q/Y
Hi, colleagues! Do you know any elegant solution for entering weekly subtotals or week ID's into module of model with calendar type month/quarter/year? Cause I faced such issue: FP&A team wants a module for calculating daily sales plan - that's ok, but another step of the process is review of that plan by BU owners who…
Use Gregorian calendar week numbers instead of fiscal week numbers
Hello community, Currently Anaplan uses its own week numbering to determine the week number. When fiscal period is different from jan-dec, then week numbers do not match at all with calendar week numbers as defined in ISO 8601. This makes it very confusing for users to adapt to these new week numbers, especially when users…
Incorrect Sum Total
Hello, I'm running into what appears to be a rounding error, however I'm not using any rounding formulas. We have a total of 625 employees being allocated across different locations. In the Total Allocation column from this module, my sum is 625: When running these allocations through a sum by location ('STG: Employee…
IS IT POSSIBLE TO LOCK THE ROLLING FORECAST?
Hi, I would like to know if it is possible to lock or save the rolling forecast for the remaining months of the current year?
NPV Function cannot get what has been provided in the technical document
Hi all, I tried to replicate the example in the Anapedia link However, I cannot get the same result as in the example as below. My module as below, my result as highlighted. Even the same cash flow data, same date column, and same formula with hardcoded discount rate. What do I miss? any idea? Thanks.

Modeling

Discussion List