-
Level 1 modal building exam medical costs
Hi, I’m attempting the question to update the formula for pulling allowances from SYS08 module. However I got the error “data type mismatch. Format other than LIST or DATE being referenced as a relation” may I know what does that mean? the formula I have keyed is: IF Employed? THEN Salary * EMP03 Employee Drivers by…
-
Confirmed PO Delivery - OFFSET
Hello, 3.3.5.1 Create Inventory Ordering Module I'm having the hardest time understanding which line item to use in the Confirmed PO Delivery formula. The threads I've read keep referring me to the POST function, but I'm not at that point in the training yet. The following set of instructions are confusing me: * Set the…
-
8.6.4 Activity: Add Formulas to Margin Calculation Module.
Hi Community, For this activity in my model I don't have the dropdown selectors. What am I missing? This is my model: This is the lesson page: I don't have the drompdown for city or product. Please help. Thanks.
-
level 1, 11.3.4
Hi, In model building level 1, while doing activity 11.3.4, I a not being able to correctly put the formula. I checked spellings and everything, and all looked good, but still it says invalid, or line item not found. Kindly look at the screenshots attached and let me know.
-
Dates reference in SYS08 not working properly
'SYS08 Employee Details'.Start Date - reference to pull the date into EMP02 Employee Expenses.Start Date pulls zeros.. SYS08 Employee Details . Start Date has valid dates in it Not sure what the issue is..Pls help
-
Level2 Certification
Hi, This might be silly question. For Level2, I uploaded the Model history as suggested in guidelines and waiting for certificate as it may take 24 hours to confirm. Do I need to submit the "Level2 Model Building Certificate" lesson after receiving the certificate or now only? Attaching the screenshot. Thanks Praveen
-
Model 1, exercise 9.2.5
Cannot understand the lookup activity Can anyone please break it down and explain what i have to do?
-
RE Activity 2.4.4.2 Check Your Work
Hi , Please guide me how zeros can be removed from Override? line item which is not coming in 'Check Your Work' Snapshot and to create view for Weeks 1-4 FY20 (Jan 20) and Weeks 1-4 FY21, (Jan 21) from my current view of DEM03 Demand Forecast Module to 'Check Your Work' Snapshot. please find below my current grid and…
-
How to undo delete for line items
Hi, I accidentally deleted multiple line items. Have been trying to restore it by going in history and clicking restore id.But Iam not able to select multiple ID of line items to restore , have to select each and go back which is taking lot of time.please suggest command to restore multiple line items at once. Regards,…
-
Level 1 Exam Activity 5 - Results are coming 0 after the calculations
I have updated the formulas But all the values are coming as Zero and got to know its wrong after submitting 4th question twice and help me to resolve the issue. Regards, Srini ***removed formulas per instructions.
-
Importing role lists in the Model
Need help to import role lists given in the excel sheet in the Model.
-
Level 2 Sprint 3 INV01 Allow Override of Shipping Method
In the INV01 Module we are asked to add the following 4 line items: Override Shipping Method Override Method Final Shipping Method Final Shipping Time Weeks The format for Override Method & Final Shipping Method are both "Shipping Method". (List) In previous activities, I was told to utilize the "Shipping Methods" List. I…
-
RE Level 1 Model Building Course
Please help me to understand why we need to create extra module named country margin report when we can take same data by filtering data from already created module named Margin calculation.
-
10.2.5 Activity: Add Employee Expenses Module
My values are getting ignored not sure why, please help attaching screenshot for reference..
-
Difference Between Budget Version & Forecast Version.
Hi Community, I needed to know the basic difference between the Budget Version & Forecast Version. Why is the Budgeted Version used in some organizations even if we have the Actual & Forecast Version. Can anyone please answer my question? It would be great if someone answers.
-
RE Verification of Saved view of DEM03 Demand Forecast Module of level2 modelling sprint 2
Hi , Please help me to verify if below is the correct view with values for Global Assumptions Grid UX and Line Chart just after completing 2.3.11.2 and 2.3.11.3 activity. Thanks
-
L2 Sprint 2.3.11.3 Create Line Chart - Numbered Months
I'm looking at the requirements for the Line Chart. I have been able to get the numbers correct. My formulas appear to be working, however, I'm trying to match the template... Where I'm struggling is the Month Numbers at the bottom of the chart. Instead of JAN 20, FEB 20... it's 1, 2, 3...24. Since I don't have Page…
-
Employees in 2 Departments
Hi everyone, I am trying to solve an issue we currently have. We have multiple departments within our company, and we are implementing a new department, Department X. There are multiple employees who are in departments other than Department X but will be helping, and we wanted to allocate part of their salary to that…
-
RE formula for converting percentage value from month to week
Hi, I have used MONTHVALUE('DEM01 Volume Growth Rates'.Growth %) formulae. please guide me if i used it in right way and values are correct. Thanks
-
L1 Exam help on Activity 5 and 6
Hi, I am stuck in the Activity 4 and 5. I am using the below formula to calculate the expense 'EMP03 Employee Drivers by Role'.Car Allowance[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] and data has been populated but it seems wrong. Plz see the screenshot. Can some please help me in…
-
Need help in creating correct Formula to get Employee expenses by Roles and Department
I assumed, I have created a formula using LOOKUP to get correct value in Employee expenses module however the outcome is incorrect when I am answering the questions related to it. Hence I believe my formula is incorrect. Not sure if someone having expertise on this can guide me to build a correct module here. Thank You…
-
12.4.1 Activity: Create Saved View for Non Employee Expenses
When I filter on Forecast months only (see screen shot) I can still see data from 2019 (second screenshot). What is wrong? Forecast months only looks like this:
-
L1_MB_BalajiBirur
Dear Team I have created a model in the space provided. Now i have forgotten hw to go back and access the model created. Could you please show me the path of the model which i have created. I want to access my model L1_MB_BalajiBirur
-
Issues in populating the start date and end date fir SYS08 Employee details
I tried to import the Employee details sheet into SYS08 Employee details module.. Except for the start and leave date, all other data got imported. I tried the Custom format for Date as well, it did not work.. If anybody has any soluton, pls help
-
Evenly Spread Amounts
Hello- We have two modules one for planning miscellaneous revenue and other for planning for OTPS. When a user enters an amount in the FY21 column the amount is not spreading evening for the forecast period. The forecast period is 6 months. Please see the attachment. I am not sure what I need to do to fix this.
-
2.3.9.1 Import data into DAT03 Historic Volumes module
Hello, I'm receiving the attached error for step 9.1 - Model object "'DAT03 Historic Volumes'.Export" could not be located. 9.2 and 9.3 seemed to work fine. Thanks, Sean O
-
6.8.6 Activity: Add Formulas to Location Details Module
My Changes Please guide to resolve the issue , actually i am getting extra drill down feature next the Module name Not coming as required output Expected output Regards, Srinivas
-
Level 1 Model Building : Question 2 not clear
not getting the answer of this question. Please suggest the answer of this question.
-
Import Data into DAT04 Distribution Center Parameters Module
Hello, I'm trying to import Weekly Safety Stock Csv file into the DAT04 Distribution Center Parameters Module. I'm not sure if something is wrong with my mapping, because I'm not getting any error, the import is being successful without data from the Csv, import results tab says ignored, why is my import getting ignored?…
-
L1MB Activity 5
Hi Team, Looking for some guidance on L1MB Activity 5. I built the following code: IF Employed? THEN Salary * 'EMPO3 Employee Drivers By Role'.Bonus %[LOOKUP: 'SYSO8 Employee Details'.Department, LOOKUP: 'SYSO8 Employee Details'.Role] ELSE 0 But get the following error message: "Automatic sum of 'EMPO3 Employee Drivers By…