-
Level 2 Sprint 2 Forecast cf formula
I have been struggling with my formulas and I just wanted to check that my Forecast cf formula was correct. It worked the first time which made me nervous. The instructions are: * If Initial Demand Forecast is EQUAL to the Final Forecast, set value of Forecast cf to 0. * If Initial Demand Forecast is NOT EQUAL to the Final…
-
Forecasting with my own data. Versions.
Hi! I'went through L1, and right now I'm trying to do forecasting for Total Profit, Revenue, Cost and Margin in the Module. (with my data) Why in my modules there is no forecast info? I do have a module with Version Details and I do have forecasting there... I do have info from 2010 to mid of 2017, and I would like to make…
-
Error in 7.2.3 lesson invalid date
I gor struck while importing .csv file into SYS08 emplyee details module i am getting invalid format error .please help me out on this
-
Inventory Ordering Module Formulas
Hello everyone Why training course think that it is wrong formula? Confirmed Purchase Order Receipt (INV01 Inventory Ordering) IF Confirmed PO Delivery > 0 THEN OFFSET(Final Shipment Amount, -Final Shipping Time Weeks, 0) ELSE 0
-
First Virtual Group Event for Indian Modelers
Hello Anaplanners in India, Glad to share that we are going to have our first Group event on 7th April 2021 10:00AM IST. Register for the event here Group Event on 7th April 2021 10:00AM IST
-
Space problem due to reporting
Hi, I have a calculation module that has 6 dimensions as well as by month. This one is then referenced by a reporting module without time (instead a list for MTD, QTD, YTD). The problem is that in order to get the numbers in for QTD and YTD I need to do a TIMESUM in the Reporting module, and since it doesn't allow…
-
Level 2 Sprint 2 DEM03
I am in the process of adding DCA's to DEM03 and I was checking my work against the example and my % growth rate is too high. It's at 14%. I checked the formula and it looks correct to me. I also checked my DEM02 model and it has the correct growth percentage rates in it. Does anyone have any suggestions about where else I…
-
Child and Parent mixed level formula
We've come up against an issue we're struggling to resolve. The situation is we have 1 Parent and 2 Children. We have the TotalStaff at the Parent level. Child 1 is prioritised and may require 60 of the staff to meet its SLAs - this is determined in a second line item. What we would like to do is be able to calculate the…
-
7.2.3 Activity: Import Data into Employee Details Module
Hi Team, In the Level 1 Model Builder activity 7.2.3 Activity: Import Data into Employee Details Module , do we have to manually map mappings for E2 Employees between source and target items ? Is there any way for the mappings of E2 Employees ? Please help as it is very lengthy process to do the manual mappings for 111 emp.
-
Level 2 Sprint 1 Volumes and Has Data? Query
Hi Everybody, For some reason, in my Has Data? Query, I get this with the right formula, with everything true? To get my volume upload to work, I had to change both the module and the volume line to "week" from model calendar - is this the issue? Not sure what else to show, the figures look as per the following models, so…
-
Snapshotting Import Problem - Unknown Numbers Being Imported
Hello, An import I have is importing "mysterious", untraceable numbers into fields. I have a module with dimensions of time (month), B3 Sales Org, P2 Material. The line item I want to snapshot is "Sales History(Units) - LAG", with formula: LAG('Sales History(Units)', 12, 0) Sales History(Units) has no formula; its a line…
-
4.8.2 Activity: Import Data into E2 Employees# List
Hi All, Has anyone completed exercise # 4.8.2 Activity: Import Data into E2 Employees# List? I am not able to procced with this, can anyone j
-
Level 2 Sprint 1 Import data into P3 SKU
Hi All, I'm trying to import data into the list P3 SKU . I couldnt find the view Build SKU in SYS12 SKU Details module though i have created and see it in the left pane Any suggestions Thanks
-
Error while using cod function in module
Getting error in sys02 region details module while using function Code i have attached error screen shot .please help me out on this
-
Help with understanding how Anaplan works
Hi Everyone, I am able to do the exercises but struggle to understand what is happening conceptually, given I am used to an excel world in finance! For example, with employees, at it's simplest: I would have a tab with all the employee details (name, start date etc), with a unqiue Key - then I would cross reference in…
-
Level 2 Sprint 2 DEM03 line chart saved view
I am trying to create a saved view in DEM03. I have pivoted and filtered the data, but when I try to show only the Baseline and Initial Demand Forecast I get this error. I get the error when I select a row.
-
4.6.6 Import Help
I'm trying to import the product.csv, but I can't seem to make it import properly. It's importing the product code instead of the name, which ends up leaving out important data such as the size and the code. Please help.
-
Rounding issue
Hello, I'm having an issue in which a sum of rounded items is still showing some unexpected decimals. See screenshot below. Is there a workaround for this other than using formula as the summary method? Thanks, Josh
-
Error Message
Hi, I have a error message that keeps on popping up when I'm trying to create a formula. Please advice. Image is attached. Thank you
-
Summarize Boolean
Hi there, Module 1 has a model calendar, and module 2 doesn't use it. The model calendar has two future years & past years. I wanted to summarize the boolean of Module 1 in Module 2. I didn't get the expected result when I was implementing ANY & TIMESUM functions. Please advise me. Thanks,