Modeling

L1MB 9.2.5
trying to put in the formula's but keep getting an error message. Tried looking for answers but nothing seems to be working
Import complete but with failures
I am trying to import the countries list (CSV file) into the G2 Country List. When I ran the import this is the result I receive. Anyone who can guide me?
activity 8.5.2 problem
hello, I am working on activity 8.5.2.Mapping options that I have is above. In this condition I have wrong results. i can not determine what I did wrong. it should look like this I tried to work on current selection that I have but US total # calculation is wrong... thank you Elcin
Lesson 8.2.1 Adding dropbox for the products
I've followed the instructions as stated in the lesson and this is my result. How do I allow the forecast to show the different products? Anyone who can help would be greatly appreciated. My model is the one without the dropdown showing nutzo bar
Lesson 6.11.2
I am having issues with this part of the lesson. My model does not match the sample screenshot even after several retrials. Please assist.
What if versions
Hello We have multiple versions in our model (ie Global 1, Global 2 etc). We created the module where user can pick the versions from the list that was created (please see the image below) and the list was named as "Model Versions" . The idea is to pick two versions and to compare it. In order to pull the data for example…
9.2.5 Activity: 5.0% not carried forward
Hi, Need help for 9.2.5 Activity: Add Formulas to Price Growth Rates Staging Module It was said to enter 5.00% for the FY19 Unit Cost % in REV04 Price Growth Rates module, but it hasn't carried forward to the Unit Cost% for FY19 in REV05 Price Growth Rates Staging module. Please refer the screenshot for reference. - Gourav
L2 Sprint 3 Shipping Method Formula
Good day, Currently I work on a sprint 3 and stuck for a long while on a Shipping Method formula. I went to Anaplan Community and found out that somehow I skipping the line item "Supplied by" in a module SYS08 SKU Details. I add lost item, run all the processes in the Action Tab and nothing happens! Can someone advise me…
Ability to rename a line item without breaking the import mapping
Description of the enhancement: If a line item which is used as the source of an import is renamed, its mapping is removed and the action must be re-mapped. To re-create: * Setup an import from "LineItemA" in ModuleOne to LineItemB in ModuleTwo. The line items will need manually mapping since they have different names. *…
Lesson 10.2.2 shared cost
Hello. I noticed my shared cost values are higher than the model example, but the other values are the same. Any ideas why?
Having Trouble Populating my LI G2 Country
Hi, I do not know why my G2 Country will not display the Country names in my G2 List. Please advise I have trouble shooting by adding a properties to help display the names and then calling upon that in my formula and that will not work, also I tried calling upon the Code and that doesn't work either. Please advise. G2…
Time Ranges with Weeks General
As a model builder working on a supply chain use case, I need to set time ranges when using the Weeks General calendar type. Our current use case requires a daily time scale, and the need to have multiple different ranges of daily data based on historicals/forecast/current week/etc. Using another week calendar type is…
Lesson 6.6.1 through 4
Lesson 6.6.1 through 4, my screen does not match with the one shown on the lesson, please help me.
Day Calculation for Working Hours
Task: Calculate the total monthly working hours for FTE's; new employees should be prorated based on their start date, employees that are leaving should be prorated based on their exit date. All absences outside the contracted allowance should be reduced from the total FTE Percentage, starting at 100%. Dimensionalize a…
SYS03 Account Product Details (L3), Cant populate LI P2 Product
Hi, I have been trying to trouble shoot populating my P2 Product LI in the SYS03 Account>Product Details Module. I have the LI formatted as a List for the P2 Product List and using the formula FINDITEM('P2 Product', ID), which will bring in the ID associated with items in my P2 Product List. I do not know what I'm doing…
2.3.9.1 Import data into DAT03 Historic Volumes module
I am getting this error during running the process 9 import data from hub. can anyone help me to resolve this error. Thanks, Aniket
Import write access to List
Hi, I want to import write access to Lists. I have this type of table. UsersCustomeraxxx1,xxx2bxxx2,xxx3 But the List item is shown by #1,#2 in User setting. How can I import to List? And I want to set the write access to combination List. Now if I set this write access. UsersCustomerProductaxxx1,xxx2yyy1bxxx2yyy2,yyy3 I…
Lesson 9.2.5
Hi. I'm on 9.2.5 and my number isn't formatted correctly even though I'm using the parameters from the lesson. Any suggestions
L1MB- 7.2.1 Help Please
I'm very close to the desired result but I cannot figure out what I am doing wrong. This is what I got after mapping:
7.2.1 Activity help needed
you can see what I have after mapping and what it should be I am not able to remove product codes thank you. Elcin
7.2.1 Activity: Having A hard time
I've been having trouble understanding the concept of mapping and how certain values are supposed to be categorized together. If anyone can help me get beyond this error message that would be great. I feel like I did something structurally wrong before getting to this point. Took a few screen shots. I've been at it for…
LOOKUP's for the DAT02 PY Revenue to CY Module Level 3 Model Build
Hi, I have tried almost everything and have been stuck on this part of the model build or a day now. I have changed my dimensioned and tried to get them to match and still not working. I'm trying to pull in Actuals from the DAT 01 into the DAT02 and Looking up LT Account A1 inthe SYS03 Module. Please advise. Thank you…
Switchover, use it or build your own?
Hi All - In the context of an FP&A use case, we're trying to evaluate whether to use switchover or just build a system module to dictate where the forecast begins and the actuals end. Would love to hear about pros and cons of both approaches. Here's what I have so far: Pros of using native switchover: 1) Ability to use…
Getting an error for a user who is not a workspace adm
A process updates a numbered list from a saved view (Module.Saved view) -> (Updates List name, parent, code and few properties) When workspace admins run this process, it completes successfully with errors only for duplicates When a user is not an admin runs the process however, the following errors appear: * You are not…
P&L Variance List
Hi, Question please. What is the best practice if I need both the columns and rows as a line item because I need to calculate the variances and the difference to maintain the clients preference on the presentation. Below is an example. thank you.
Set Period as Column in a Module
Hi! I have to create 2 reports, one with year only as column and another one with quarterly as column. I do have the data module with month as column, but that's not the result that I want. Previously I just show the data module and hide every months then show Q/Y only but I don't think that's a good practice, since if…
Ability to include a Line Item in a Line Item Subset via an import process
Currently, the only way to include a Line Item in a Line Item Subset is to manually go into the Line Item Subset and check the Boolean to add it. What I'm proposing is the ability to import into a Line Item Subset's "include Booleans" so that one can include/exclude Line Items from a Line Item Subset based on a Boolean…
Demand Forecasting
Dear Community, I am trying to build a system with 2 regional sales manager and one sales head. Regional sales managers should be able to submit their projected numbers and sales head should be able to see, who has submitted and what have they submitted in the Anaplan. Do we have any courses around this in the community or…
DATA02 import issues
I am struggling to import data over to the DATA02 module. I believe I have the right options selected. I am just not sure why its not populating all the data.
NEW UX: Drilldown to be formatted & have the ability to be expanded
The current drilldown functionality in the New UX is not compatible for complex formulas. It would be a great improvement if the formulas can be formatted (like in the classic) with bolded text for functions, and indentations for IF/THEN/ELSE. It would also be ideal if the drilldown window can be expanded to cater for…

Modeling

Discussion List