-
Drill Down
Hi, I have a formula applied to a line item which is not giving out the correct result, and if I drill down the formula, the pop-up screen is not considering he other modules for calculation which are there in the formula. Can you help where is the lag in the formula. Have attached a screenshot for reference. Thanks.
-
Level 1
Hi I'm on question 6 of Level 1 and I keep getting this error. I've double checked my format and names and think they are right so I don't know why i keep getting this error Medical Costs = EMP02 Employee Expenses.Medical Costs[SUM: SYS08 Employee Details.Region2, SUM: SYS08 Employee Details.Role2]
-
Update Historic Volumes for Baseline Forecast SPRINT-2
The formula for 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' is invalid: Datatypes do not match for 'IF' function: NUMBER, BOOLEAN I used the formula IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' ELSE OFFSET('SYS01 Time…
-
RE: Where to build a model in anaplan
I started my journey in anaplan but have no clue where to start my build of the model Some please help on this
-
Number format in the line items
Hello, I have a problem with formatting a line item. In the source/input module I have a many line items, some of them are presented as % and some of them are as normal number (No problem here, because I change the format per line items accordingly). BUT In the OUTPUT model, I used these line items as LISS and pulled them…
-
Top Level Aggregation while Using Line Item Filters
Hi Anaplanners , I would appreciate if someone in the forum could help me to resolve the below modelling issue that i have. I have 4 dimension on which the business needs to do their planning ,forecasting process- Segment, Legal Entity, Department and Account. These dimensions are independent of each other and don't have a…
-
1.4.3.2 Import Data & Add Formula - Need Help
I am trying to populate this module and I have hit a road block (yet again with mapping) 😭😭😭 Can someone please explain what I did wrong - attached are screenshots of the mapping and the code I was supposed to put in.
-
NPV without an outflow
Good morning I am building a model consisting of future variable monthly cash outflows without any cash inflows. I need to calculate the NPV of that in order to convert that into a liability using the variable cash outflows as down payments.. The NPV formula require cash in and cash out. What are your suggestions?
-
1.4.3 Activity: Create System Module - Mapping
I am trying to populate this module and I have hit a road block (yet again with mapping) 😑 😪 Can someone please explain what I did wrong - attached are screenshots of the mapping and the code I was supposed to put in.
-
Implement Slow Changing Dimensions in Anaplan
Hello I am facing a scenario where I need to implement Slow Changing Dimension ( Time Validity using Start Data and End Date ) for product & customer combination. A product can be sold to more than one customer. And the price varies over time for each of these product customer combination. I need a module to track the…
-
Can i create a Time Range with 3 months
Hi, I am looking for a functionality to setup time ranges with 3 or four months, is it possible? Suman.
-
Level 2- Sprint 1- 1.3.6
Hey everyone, I am hoping someone would be able to provide some clarification for me. I am on lesson 1.3.6 of Sprint 1 for Level 2 and it states that the following items need to be in the saved view. What are the subset line items? "Include: Code, Parent, and subset line items" Thank You, Laura
-
Hierarchy Build - Parent and Child are in same column
Hi All, I am faced with this hierarchy where P1 and P2 are parents and Prior Items are Children of it. I am bit confused how to build this hierarchy in system as data for both child are in same column in file. Does anyone has an idea how I can accommodate this? Consider structure of data exactly same as the image. Thanks…
-
3.4.3 create country summary module
while writing the formula for safety stock flag count line item i used this formula 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM:'SYS08 SKU Details'.Country Made In ] But it is giving error as data mistmach. can u help me
-
Adding a user-specific selection to a calculation without using the User list?
Hello, i am trying to find a solution to the following user story: There are a set of modules for a reporting page that currently consist of multiple dimensions (we cannot use a combined list of only possible combinations due to the users not liking the loss of flexibility). These modules return a calculation that needs to…
-
Level 2 Sprint 2 DEM03 and DAT03
Hi Team, When reviewing my latest workings and forecast per DEM03 and referencing this against the example for the baseline forecast DEM03 in sprint 2, I couldn't help but notice that my figures are different for the future periods commencing in Week 1 FY21. I'm not sure whether this is related to an error in DAT03. Please…
-
1.3.10.2 Import Data into G2 Country List - Mapping Issue
Hi - I'm trying to map data for 1.3.10.2 Import Data into G2 Country List Attached is my screenshot. Can someone explain what I'm doing wrong? I keep getting invalid parent. And if you can explain why we should map things to where they should go, that would really help for the future. Thanks!
-
Model Building Best Practices
Hi Everyone, Hope everyone doing good I am working on a best practice model building document and just wondering if you can recommend any checklist document before starting a new development I am aware of planual document but was looking for a shorter simple version so that the whole development team can follow the best…
-
Line items number
Hi Is there a limitation on the number of line items in a module?
-
9.2.5 Activity Error
Hi I am not able to edit 0 to 5% in unit cost %. Please guide what could be wrong here. Screen shot attached. Thanks -Pooja
-
User filter-User Mapping
Hey, I have been stuck on this particular issue for sometime now, wanted to check if someone here could help me out:- I wanted to filter list items of List A for the end user based on a non system users list subset. I have a module 1 dimensioned with list A, one of the line items in that are list formatted to a non native…
-
Defining levels on Ragged List
Hi team, Is there a method to define levels within a ragged list? I have a ragged list which is being used in a complex filtering exercise & for 1 of the conditions I want to only display the Lower level of of the ragged list (see screenshot whereby both Income and Profit & Loss are L1 but I wish to create a condition for…
-
Level 1 Exam
Hi Can anyone please let me know if there is time limit on Level 1 exam? what is the format? how many tries we will get for each question? Thanks -Pooja
-
Custom Filter for Multiple selection
Hi, I want to create custom filter using a dropdown but in that dropdown I want to do multiple selection. I tried doing it but was successful with one selection. I even tried using Boolean selection method but that is not a user friendly way. Can anyone please help me what should I do for multiple selections in a custom…
-
SYS01 DEM03
Hi Team, I am struggling with DEM03 and the SYS01 Time Settings by Week Firstly, in SYS01, 1st Forecast Year remains empty, please see attached the blueprint of the same and the associated formulae as well as the time settings view. This in turn I believe leads to DEM03 Demand forecast to be empty for Baseline Forecast.…
-
While Importing a numbered list the name row is not getting populated
I am trying to import a numbered list. while importing I have selected the source as Code and Target as Employee list. when I run the import , all the column headers(department, country) are getting populated , except for name. What could be the issue here?
-
Calculation Function - Minus Disposal Month
Hi Everyone, I need some help in building a model. So basically, from the above image, I have manage to read the Total Nominate TEUS for each month but I'm not sure How to: 1) let the system to know that, if there's a disposal in a particular month (eg. March and June) then the follow month (Apr and Jul in this example)…
-
9.2.5 Activity help!
I read a bunch of other comments regarding the 9.2.5 activity and tried to follow along to troublshoot the error I was receiving. however, I am still unable to find the root cause of the issue. I keep getting the below error. Can someone please help me in figuring out where I may be going wrong?
-
Boolean Filter Line Item
Hi team, I have a Filter module to calculate filtering at a row level due to some complicated requirements. There are 3 dimensions being: Location L3 SS: GL - EBITDA Report (L3 in Hierarchy) SS Channel - Budget Channels (No Hierarchy) On Level 1 of the GL dimension (List Item: Income) it is returning TRUE in the 'OPEX…
-
Level 1 Anaplan Model Training Data Mismatch
Here are the formulas that I'm using, but every time I input them in EMP02 I get this error: Data type mismatch: format other than LIST or DATE being referenced as a relation Bonus - IF Employed? THEN Salary * 'EMP03 Employee Drivers By Role'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee…
