-
Query on conditional formatting in Level 2 Sprint 3
Hello In the training lesson Level 2 Sprint 3 -3.3.4 Create Stock Exceptions review ux page, they have asked me to * Apply conditional formatting to highlight the Stock Exception count greater than zero. * expected output I have applied conditional formatting in custom view while publishing the module into ux page. The…
-
11.3.4 Actual and Forecast Values are the same
Hi there, My actual and forecast values are showing the same output. My forecast values should be different as seen in the example, but I can't figure out how to show the different output for the forecast values.
-
2.4.7 Activity: Create Saved Views for UX
My DEM03 gROWTH RATE% FORMULA: 'DEM02 Volume Growth Rates by Week'.Growth %[LOOKUP: 'SYS08 SKU Details'.Product Family] It went through, however in further training 2.4.7 of Sprint 2 it is asking me to create a saved view which should look like ( below screenshot as per the course) But this issue is my DEM03 contains…
-
2.3.9.1 Import data into DAT03 Historic Volumes Module
Hello, I have been having difficulty completing the 2.3.9.1 activity. I utilized this forum to address my previous issues but I am still having trouble. The Historic Volumes aren't being populated. 9.2 and 9.3 seem to have populated appropriately. Please see the screenshots attached.
-
Lvl2 1.7.3.1
I am not able to import P3 SKU from the data hub saved view
-
Why is 'Expense Type' not a list in 'Transaction Data' module 'Essentials of Model Building'.
Why is 'Expense Type' not a list in 'Transaction Data' module 'Essentials of Model Building'. Section 6.4 of 'Essentials of Model Building' guides us to create 'Transaction Data' module with 'Expense Type' as a line item and then formatted as 'Expense Type' List. Why can't we have it as a List when creating the module?
-
3.36 L2 Sprint 3
The POST formula seems to be operating correctly, but I am getting a different number in Week 3 from the example provided
-
L1 EXAM Q 6
Hi, Everything looks good but answer is wrong. Please help me
-
L1 exam
Hi, I am getting L1 exam now, can I skip to others questions? There is an option, Submit ! Thanks, Mark
-
Formula
Hi, I am following all steps but it doesn't work properly. where am i going wrong? Please guide me? Thanks, Mark
-
Level 2 Sprint 3 INV01- Beginning Inventory Calculation Not Working
Hi, I am sure I am using correct formula for calculating Beginning Inventory but my module doesnt seem to reflect that. Formula - IF 'SYS01 Time Settings By Week'.'Not 1st week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory. But output for first month is coming 0 since…
-
REV03 Margin Calculation Module
Hi, When I check the REV03 Margin Calculation Module in Level 1 Course, I see that Cost of Sales is greater than Revenue in almost all cases after Jan 20. Maybe I am doing something wrong but I think this is not normal. Can you double check them for me? Thanks, Mark
-
Sales Planning Model: A2 List
Hi, I'm having trouble when trying to import into the Sales Planning Model: A2 List in the Sales Planning Model. I created the necessary System Module in the Data Hub in order to use to populate the A2 List. I also filtered the module so only the valid Account>Product combos show and saved as a view. I then imported this…
-
2.4.7.1 Conditional formatting
I have added the conditional formatting for Final Forecast, but not sure what to do for Initial Demand Forecast to make it look like the material provided screenshot. Here is the rule I have in place currently My other question is if it is okay that I do not have any data like the material shows for FY21?
-
2.4.11 Creating Roles
I am stuck on creating the roles and which access to provide to make the dashboards visible. Will the dashboards not show if they were made on My Pages?
-
8.5.3 Activity: Import Data into Volume Inputs Module
Hi everyone, I'm getting this error message and I don't know what I'm doing wrong.
-
Level 2 sprint 2 2.3.13 Activity: Create Global Demand Assumptions UX Page
Hi All, The task is to "Build the UX page using the guidelines that follow" (screenshot attached) Previously I was asked to create some saved views to use for this UX setup. However, It seems that time is both a row and selector, allowing the ability to toggle between H1 FY20 and H2 FY20. Any suggestions or ideas on how I…
-
Level 2 1.3.10.3 issues
Hello All, I am having a bit of an import issue when trying to create the G3 List for my model. I have gone back and resaved my views to include line items in the view to ultimately import into my model. The view in question should look like the view with the white background, however mine is turning out like the…
-
FORMULA HELP
Havıng hard tıme on buıldıng formula doıng 1.5.7.2 any advıce wıll work
-
L2 2.4.3 and 2.4.4 DEM03
The micro-lesson on 2.4.3 shows some different formulas than I have been using and then 2.4.4 shows the fy21 baseline forecast populated. Is this information to be updated further in the L2 Sprint or where am I making a mistake?
-
SYS14 Automatic sum over Flat List not possible
The line item "Data?" in Data Hub Model: SYS14 module was asked to reference SYS12 SKU Details and SYS13 Account SKU filter which were created during Level 2 Data Hub. However, both SYS12 and SYS13 were using SKU Flat as dimensions (as instructed in Level 2 training). When trying to reference the two modules, I got error…
-
2.3.9.1 Import data into DAT03 "Expected week number in date/period"
Hi Anaplan fam! Since I have read almost every post about importing into DAT03 and checked the instructions many times, it seems I have exhausted all possible options. The only way I can import from Datahub is by using Match names in the Time tab. When I add line item "Offset Volumes for 1st Forecast Year", the value is…
-
Formula
Hi, I don't understand it doesn't calculate margin/revenue properly. Thanks, Mark
-
Starting Your Anaplan Training
Getting ready for Anaplan is key to a collaborative and successful project, and our Level 1 Model Building course provides the quick start you need! Level 1 Model Building is comprised of 15 parts and a certification exam that gets your team enabled, empowered and excited about using Anaplan to drive business value.…
-
Page Builder Training
Hi All, I am trying to locate Page Builder Training. Can anyone help please? Thanks Karolina
-
Level 2 - Sprint: Activity import Data into DAT03 Historic Volumes Module
Hi guys, I've been trying to inport the 'Historic volume.csv' to the DAT03 Historic Volume Module for the past 2 hours. I already watched all the videos about importing data to module, etc. But I keep receiving this error, "invalid line item identifier", and I don't know what else I can try. Could someone give me a hint?…
-
Formula
Hi, Although I am following all the steps, 'Cost of Sales' line item shows different value (more than revenue) for the years of 2020 and 2021 in my module. Can you guide me, please? My screenshot: Expected screenshot: Thanks, Mark
-
Anaplan Connect 3.0 Training Refresh
The Anaplan Connect training was recently revised to include updates and best practices. Anaplan Connect is a simple connection tool for integrating data to and from Anaplan. This training provides an overview of Anaplan Connect 3.0, this includes: * 3.0 Overview * Setup requirements * Anaplan Connect Guide * Downloading,…
-
DEMO 03 Demand Forecast. Baseline Forecast formula
Hi, I am trying below formula for Baseline Forecast, its working for FY20, but for FY21, data is not populating as expected. IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' ELSE OFFSET(Final Forecast, -52, 0) Below is the Time Ranges selected for…
-
9.2.5 Activity: Add Formulas to Price Growth Rates Staging Module Error
Hi, After I add Formulas to REV05 Price Growth Rates Staging Module, checking my work with the instructions as below: In the REV04 Price Growth Rates module, change the page selectors to US and Chocolates. Enter 5.00% for the FY19 Unit Cost %. Then, open the REV05 Price Growth Rates Staging module. Change the page…