-
Level 3 Sprint 2
Hello SYS06 Territory Accounts Details module was pre-populated with formulas for some line items but nothing is showing. Do we need to adjust G4T Territory>Account# list in order for this formulas to work? Thanks
-
Level 2 Sprint 2 Activity 2.3.9.1 Import data into DAT03 Historic Volumes module
My Export View from the Data Hub model always has the Line Items of Volumes as a column. The first column can't be ignored in mapping. Although the data can be imported correctly, there's always an error message. Is there a way to avoid this? How I add pivot the view so that the Volumes wouldn't show up as a column? Thx!
-
Question 6 in level 1 model building exam
Could anyone who has finished the exam show me the formula for question 6? I failed 2 questions for this part. I think I just need to refer the relevant numbers from another module and apply selections, and then it could be done. However, my way didn't work. Here's my formulas. Thanks very much!
-
MB Level 2 Sprint 1: 1.5.2 Activity: Import Data into Beginning Inventory
Hi, I currently trouble importing data into the DAT01 Beginning Inventory module. Kindly advise.
-
Level 3 User Story 1.5 numbers mismatch
Hello. 1st question - is this total for the US? 2nd question - We match on Candyate but we do not match on All Accounts. Has the data changed? Or is it me doing something wrong? Training Screen shot: My screen shots:
-
Level 2 Sprint 3 TRA01 module creation
Hi - I am facing issues when trying to create the TRA01 module. I am getting zeros when I am trying to map the weekly values: TRA01 module - formula Shipping Time = WEEKVALUE('DAT02 Shipping Metrics'.'Shipping Time (Weeks)') Cost per 1000 Units = WEEKVALUE('DAT02 Shipping Metrics'.'Cost per 1000 Units') Results Please help…
-
Hi. Who can help? :) filters from saved view do not remain active on grid view on my pages
Hi. Need some help :) I am at the lesson 13.6.3 point to add a grid card on My pages. The issue is that the saved view from the module part, with filters and some hide line items do not remain available when I selecte it to the grid card side. The filters remain active but the hide lines appear again on the grid card . Do…
-
Can someone HELP on User Story 1.6 PLEASE
Can someone dummy it down for me and tell me what two modules should i compare here? I do NOT understand what exactly am I being asked to do. I did this and I cant understand AM i wrong? Can i move on to next user story without downstream impacts? Am I way off? Am I missing something?
-
How to return the day os the week (e.g. "Monday") based on the date of the module
Hi, I have module with time scale "day". I have a line item called: Workday, and I need it to return the day of the week (e.g. "Monday") based on the date of the module. I need this so that the person has to tick only the weekdays. Can you help me ? Thank you in advance!
-
Absolute value on List
Hi Community, I would like to inquire something to make absolute value on a module with specific list members only.So the requirement is that the COS and Admin list members will be alsolute value. see below. Blueprint view: only the highlighted items should have an absolute value. the columns are the line item and the row…
-
2.3.9.3 Update Historic Volumes for Baseline Forecast
I do not seem to be seeing the 1st Forceast Year as a line item in my SYS01 Time Settings by week module. Could someone assist me with what the problem could be?
-
Extending a week
Hi All, Is it possible to add a week in the model calender for a new year without adding a new year in the time settings. TIA.
-
L3 Sprint2 User Story 3.2
Hi dear community, After a great journey of Anaplan learning which went really smooth, I'm on the last mile and it's taking too long for just two line items I can't find a solution for : Target : I'm using the TAR02 Account Review - Final Sales Targets No of Accounts : I'm using the SYS02 Account Details - Count I have the…
-
Level 2 Sprint 3 Product Replenishment UX Page
Okay so I've been stuck at it for so many hours now. First, I'm noot able to add the instructional text to the grid card. Second, I'm not able to do the conditional formatting for the INV01 module in the UX page due to the min and max. I'm attaching the screenshots, please help!
-
Error
Hi Community, I was trying to follow the instruction given by @pyrypeura on conversion of time to text. I followed how he made it but I keep getting error. Am I doing something wrong here? Kindly correct me if I am doing something wrong. THanks and Regards,
-
3.3.7.2 Add DCA to INV01 Inventory Ordering
Add Read and Write Access Drivers to INV01 Inventory Ordering module to set up Dynamic Cell Access to perform as shown in the example below: Week 1 & 2 (blue highlight) Week 1 shows the result when Submit Purchase Order Request? is NOT checked.Week 2 shows the result when Submit Purchase Order Request? is checked (however,…
-
Date Conversion
Hi Community, Can i have help in converting date into a text formatted version date. Like1/1/2019 convert it to January 01 2019. I already have the days line item I just need to convert it to a text format date. Any ideas is welcomed, Thank you and Regards,
-
Where can I find the completion Certificate
Hi, I passed the Anaplan Model bulding level 1 exam. After submitting the answers it gave the result and an option to print. Now where do i find the certificate? The exam module in courses still shows 0% (not complete) Please suggest
-
Lvl 3 TAR04 Account segment total by country
Hi, I was validating my build of TAR04 module. While my All Segment data is matching, the individual segment data(small,medium,large) aren't. See attached image; first grid is my build and second the one from training. I checked my system module and all segments are mapped to each account. what is it that I am missing?
-
Anaplan Level 1 Certification cost and support
Does Level 1 and Level 2 certification cost me anything? Will able to download the Anaplan Certificate after completing both the levels? What does instructor led version mean? Please brief. Please find the attachment.
-
4.6.7 Activity: Import Data into P2 Products List
Let me know what am I doing wrong here. getting different result while importing.
-
Level 3 - User Story 1.6
Why am i getting 0s in Previous Year Actual Revenue - even if i use the SUM: 'SYS03 Account>Product Details'.'A1 Account' for the SUM, i am still getting ? Is my Initial Account Sales Targets correct? What is the math for Final Account Sales Targets? Do you want me to show Final Account Sales Targets in TAR04? What exactly…
-
9.2 Model Build Specifications (I do not see the values being populated quarterly)
Can someone guide why this is happening?
-
Level 3 question
Hello I am asked to import Baseline Financial Foreact into the model and you have given me a file. I did that. Then i am given the TAR01 module where i have to show the baseline financial forecast - how do i show that since in the sounrce module (Baseline Financial Forecast) i am not given a date that i can convert to a…
-
L3 Account Segment by Country
Hi, I was validating my build of TAR04 module. While my All Segment data is matching, the segment data aren't. See attached image; first grid is my build and second the one from training. My understanding is that this would happen is I dont have the right Segment for each Account. Can you let me know if this is possible?
-
Level 3 Sprint 1 TAR01 Detailed Sales Targets - please advise
Hello Anaplan Community! So here is a problem I’ve been struggling with for more than a week. Please help me to understand am I right or wrong. So I have a TAR01 Detailed Sales Targets module: In PY Country and Product Family Sales line item I have Baseline Financial Forecast from TAR01 Sales Targets module looked up by…
-
LEVEL 2 SPRINT 3 ENDING INVENTORY
Hi, I am using this formula for ending inventory: Ending Inventory = Beginning Inventory + Confirmed Purchase Order Receipt- Forecast Demand but i am getting the following error message: 'INV01 Inventory Ordering'.Ending Inventory has NUMBER format but the formula resolves to BOOLEAN format Please help! Thanks
-
Decimal difference
On the L3 training: Why does your screen shot include decimals in the lowest level and does not calculate in decimals on the lower levels? My results are all one decimal place. If i leave it with one decimal place would that cause me mismatches downstream?
-
Level 3 sprint 1
Hi Experts, A couple of weeks ago, I imported data into the below module. Then, I summarized the above data into the below module. I have no clue to get data PY Country and Product Family Sales in the below module. Please advise me. Regards,
-
Find item function
can someone explain how finditem function work with an example?