-
L1 Model Building Activity 6
How would I go about adding Department and Role to SYS08? I don't believe that was a part of the exercises which I followed step by step. This is what I have for my SYS08: I have Department and Country...
-
Level 1 Exam - Activity 5
Please confirm if the formula is correct for Medical Costs. I missed the link now (and a bit lost),since My question 5 got wrong.I undertand model building activity in Question 5 is to be proper to answer question 6. Now i want attempting Question 6 and not clear what formula to use for answering question 6. Urgently…
-
level 2 sprint 3.3.5
i am not getting correct values. please help
-
L1 Exam Activity 5
I get the following error code when trying to change the Formulas: IF Employed? THEN'EMP03 Employee Drivers by Role'.Car Allowane [LOOKUP:'SYS08 Employee Details'.Department,LOOKUP:'SYS08 Employee Details'.Country ] else 0
-
Level 1 Exam - Question 6
Iam getting blank data for question 6 in REP04 Employee Expense Summary for questin 6 Total expense for FY21 medical cost- Europe/Staff members Following is the the screen shot for result in REPO4 in both grid and blue print. Please help to have the correct formula for Medical cost.Iam blank frankly as of now. blue print
-
L1 Model Builder - 11.3.2 Activity
Hi everyone. I am completely stuck on this activity. I have read all of the questions and solutions on the topic of 11.3.2 activity and have tried all the posted solutions, but nothing has worked so far. I have attached all of my mapping screenshots. Everything looks like it mapped correctly. I have also attached my error…
-
Lesson 9 - 9.2.4 Lookup Activity
I am doing activity 9.2.4. I need to create a lookup formula for the COLA modules. However, there is no COLA module creation exercise in any of the lessons. And there is no model to download with COLA modules built in. How did you complete this activity?
-
Level 2 - Sprint 2 - 2.4.8
Want help with the attached one. Should the values match with the ones in the activity or its an example for how the grid should look like? The saved view from which the grid is formed was done based on the activity which is SF based water taffy. Please let me knw, what changes to make. this is like this because, detailed…
-
L2 Sprint 2-2.4.7.1 Create Demand Forecast Grid UX saved view
Hi All, In Level 2 Sprint 2 in activity 2.4.7.1 it is asking to create a saved view with the same name Grid UX it has asked in activity 2.3.11.2. I am confused here as in old UX version it has saved it as Demand Forecast Dashboard Grid. Can anyone help me in here?
-
[Updated] Level 2 Sprint 2 DAT03 Historic Volume
Hello Experts, On DAT03 Historic Volumes my volume line item don't match with the values for FY20 but does match with Offset volumes for Fy20. I used the following formula: IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET(Volumes, -52, 0) ELSE 0. also in DEM03 demand forecast pulls only FY20 data not FY21,…
-
L2 - Sprint 2 - Activity 2.4.7.1 Create Demand Forecast Grid UX saved view
Hi, Can somebody please help me with this formula?
-
level 2 sprint 2.3.9.2
why run is showing error?
-
Level 1 model Building Activity 5
Hi @JaredDolich i Have stack with how to update the formulas for my Line Items in my Module EMP02 Employee Expenses. This is the formula i am using IF Employed? THEN Salary * 'EMP03 Employee Drivers'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0 i have read other…
-
Level 2 - Sprint 2 - Activity: 2.3.13.2 Create a User Experience Page
Below I am attaching my UX page. Can anybody let me know if it is right and the values pertaining to the selectors are right? If any more additions required, Do let me know.
-
level 2 sprint 2.3.13.2
is this correct?
-
L2 sprint 2.3.8.4 Create DEM02 Volume Growth Rates by Week module
When I am using monthvalue function it is not working Plz reply
-
3.3.5.4 Update INV01 to Allow Override of Order Amount
One of the Product Supply Manager user stories for this sprint included the ability to override suggested order quantities. Update the INV01 module with additional line items to provide this functionality. In the INV01 Inventory Ordering module, add the following line items: Line Item Format Purpose Override Suggested…
-
How can import Shipping time correctly here?
How can import Shipping time correctly here, '1.6.2.1 Import Data into DAT02 Shipping Metrics Module". Could you help me please?
-
Level 3 Sprint 1- 4.2 user story
Hi Experts, I don't have FP&A model to import the data for the list. Kindly advise me for the import process
-
3.4.4 Activity: Create Stock Exceptions Review UX Page
Is this right?
-
Level 2 Sprint 1 1.3.10.4
Can anyone explain why I'm not getting the view as displayed in the instruction? There is no check in my view? Thanks,
-
3.3.5.2 Inventory Ordering Module Formulas - Shipping Method
Hi everyone, I appreciate any help that can be provided, I was very stuck on the formula for Shipping Method. I was trying the formula below and getting error "Format of mapping used for lookup doesn't match any dimension of the source". I believe I am using the correct module line items, but am struggling to understand…
-
Level 2 sprint 1.3.3 review lists in Tree View
Hi, i have imported all 3 files (Regions, Countries and Locations) when checking the work against the example given i have no lists showing in tree view. It should look like this: but i have this data was imported in blueprint as so: which came out like this pivot is can anyone help? this is the case across all 3 (regions,…
-
Import Challenge
Summary: Practice the importing skills you learned in Level 1 Model Building by completing this challenge. In this activity, you will be modifying to your Level 1 Financial Planning and Analysis model to support a new planning initiative at Unicorn Candy Company. Audience: Completed Level 1 Model Building, Preparing for…
-
Sprint 1 - 1.3.10.2
Can u help with the mapping please, don't knw what the error is.
-
Level 2 - Sprint 3 - 3.4.3 Activity: Create Country Summary Module
Hello all, I'm having trouble figuring out with this error that I'm getting. Can anyone help me out? My formula is this: 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Country Made In] Thank you
-
Level 1 Exam REP04 Employee Expense Summary
Hi, Formula doesn't work here, there is no value in REP04 Employee Expense Summary, how can I solve this issue, could you help me, please? Thanks,
-
Level 1 Exam
Hi, Level1 exam, activity 5, Employee Details by Role are imported successfully but role list couldn't see in the table. How can we solve this issue, could you help me please?
-
Level 1 Model Building Exam - Model Building Activity 6
Hello all, I have been trying to work through Model Building Activity level 6 and cannot seem to understand why my lookup formula is off. I am trying to add a formula to REP04 that shows Total Salary expenses by Region and Role. The formula I am using is 'EMP02 Employee Expenses'.Salary[Lookup: 'SYS08 Employee…
-
3.3.5.4 Update INV01 to Allow Override of Order Amount
Hi Everyone, Please advise If I am correct or not. I am having a little difficulty to understand what has been asked to created here. We now have two check boxes or Booleans "Submit purchase order Request?" and "override Suggested Order Amount?". My question is does only one box needs to be checked at one time or they both…
