-
LEVEL 2 - SPRINT 2 - 3.3.5.2
Can I know if the formulas are right and I need help with the other formulas
-
10.2.5 Add employee expenses module
How do I correct this ? Do I have to redo the whole module ?
-
Formula
Dear Members , I have used the formula for ' Final Forecast' in Demand Module of sprint 2 . Is the below formulae correct ? IF NOT Override ? THEN Initial Demand Forecast ELSE Override Forecast Can Someone comment on the same , thanks
-
REV03 MARGIN CALCULATION-ERROR
Hi, In reporting modules while calculating margin%, margin% is correctly calculated when i am in lower hierarchy(eg.locations). But w)hen i change it to Region(eg:Americas) margin % is not calculated based on formula but adding the locations margin%. Foe me i am getting the same type calculation for all margin% line items…
-
10.2.1 Add non employee expenses module
Hi Community ! 😀 I'm learning the training and I completed everything but the formula is what holding me back for the past 30 minutes.. So below is what I have : & from the training I am suppose to have ... Thanks in Advance for your patience ! @Akhtar.shahbaz
-
10.2.2 Import data into Non employee expenses module
Hi community ! Please bear with me as i have a learning disability. I keep receiving this error message ... I would greatly appreciate the assistance. Thanks in advance ! @Sowjanya @jagadishdash
-
No of attempts for each of the level 2 Exams
Hi Members , How many attempts can be made for each of the level 2 ( Sprint 1, 2, 3 etc ) exams ? Thanks
-
Demand forecast populating issue
Hello Members , While in the " DEM3 Demand Forecast Module " I am facing an issue . By Applying the below formulae IF 'SYS01 Time Settings By Week'.'1st Forecast Year?'THEN 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year'ELSE 0 I am able to populate " Base line forecast " for FY20 weekly . But I am not able…
-
2.3.10 Activity: Create Demand Forecast- Need Help
I'm not getting any values for my 3 line items after the baseline forecast. I cannot figure out why this is happening. I see growth percentages in my source modules, but they are not being carried over in my formula for my "DEM03 Demand Forecast Module".
-
Create DEM04 Demand Export Module
Hello, please help me define the summary methods of Demand Export Module to match my results with the correct answer from the course. here si my results The correct result is attached
-
L1 Training Video Example and the Importance of Denominator Choice
The User Story for L1, slide 8.7.4, Challenge #1 (Catering Analysis) provides the SUM Demo Model and asks for a list of goals scored summed by each player's favorite breakfast, in order to plan the menu. Summing the goals as requested by the assignment reveals that the players who chose Cold Cereal collectively scored 4…
-
TAR01 Detailed Sales Targets
I am struggling with LI "Initial Account Sales Target" any hint please. Also could be please confirm rest line item is as expected.
-
Level 2 - Sprint 3 - 3.3.7.2
Can anybody let me know if the below attached screenshot is right with regarding its format?
-
8.8.2 Activity Add Formulas to Country Margin Report
Hi Community ! 😊 So Im completing the training and Im suppose to have the same page as my screenshot below : But Mines Turned out like this : Some help would be appreciated Thank you in Advance ! @Akhtar.shahbaz Im not sure if I should change it back to sum But i dont think so .
-
Help on 8.5.3 import data volume inputs module
Below Im trying to map everything out. Im currently trying to complete the activity. I looked over the instructions this is my screen shot : But I have Volumes on the other tab The product code is not showing as an option just saying the word column.... @Akhtar.shahbaz Please and thank you 😄
-
DEM 03 Baseline forecast formulas
Hi, I am trying to write formulas for this activity: Here is what I am doing: But the results are nor correct, How should I change the formulas and/or summary methods? Thanks
-
8.2.2 Add volume input modules
My dates are not showing. It is only showing Jan Instead of the training screenshot . Its suppose to look like below: @Akhtar.shahbaz @ryan_kohn Please and Thank you
-
2.3.9.1 Import data into DAT03 Historic Volumes module- time mapping problem
Hi, I am trying to Import from Data hub. This is my mapping: And I got this error message: Any guidance regarding this? Roya
-
Level 2 Model Building (Sprint 1) - Activity 1.3.3
In the level 2 - 1.3.3 activity, am i importing the files correctly? For example, when i import the county flat list, the directions tell me not to appoint a parent. So I proceeded per my screenshot below. is this correct?
-
Import Shipping Expenses into OTH01 Module
I have been trying to import for the shipping cost line item in OTH01 Non Employee Expenses Module and still getting code error. Help me in figuring out what is wrong?
-
Level 2 Sprint 3 Module INV01 : Formula for Shipping Method
Hello !!, @Misbah I have been doing Level 2 Sprint 3 - INV01 Module and stuck on formula for Shipping Method as i am getting multiple type of errors while doing LOOKUPs. In order to populate values for Shipping Method Line Item, I need to look into SYS07 Module(Distribution Center Details) for Default Shipping Line item…
-
L1 MB: Lesson 6.6.3 Add Formulas to Time Settings Module
Hello, Formulas was updated in the Time Settings module as per below instructions. But in grid view I notice my module is missing check marks in FY19 (Actual Period), FY20 & FY21 (Forecast Period) columns which is different to the example module. I've gone back to the instructions and the formulas and formats are the same…
-
Lesson 9.2.5
Hi all, I am trying to input the formula in unit price % in rev05. I am getting the error "Dimension of mapping used for lookup doesn't match any dimension of the result". However, when I input the formula in unit cost % in rev05 it works just fine. I have went back to look at SYS04 and SYS06 formats/formulas and haven't…
-
Level 1 Activity 5
Getting an error for dimension of mapping used for lookup doesn't match any dimension of the result.
-
Level 1, 9.2.5 Activity: Dimension Error
Hello, I'm working on Level 1 Model Building (9.2.5: Add Formulas to Price Growth Rates Staging Module). When I try to enter the LOOKUP formula for the line item 'Unit Price %' in REV05, I get the error: "Dimension of mapping used for lookup doesn't match any dimension of the result" I verified that in REV05 the "Applies…
-
3.3.6 Activity: Test the Shipping Cost Formulas
The Final Shipping Time Weeks is right? Why is it not 1 in my module?
-
First day of the week for fake week
Hi, I have calculations in a module with time day and the calendar type is calendar month. I have created fake weeks and needs to calculate first day of the week and last day of the week. Havent found a good solution for that. Does anyone have an idea?
-
Level 2 Sprint 3 activity 3.4 & 3.5
Hi, So while creating these UX pages I noticed my conditional formatting and and my chart as well is starting from week 5 onwards and not from week 1 , I don't understand the reason behind this , can someone explain , what I might be doing wrong .
-
Calculation Error
I am trying to calculate the phone costs for a department in December 2020 and medical costs for a department in December 2020, as well as fiscal year totals for certain departments. Been on this for 2 weeks now. The formulas I am using in REP04 are producing numbers, but they are incorrect. Here is REP04: It draws from…
-
Level 1; Course 8.5.3 - need assistance mapping volume into module
I’m having issues mapping out the attached file; any assistance would be appreciated!! Thank you!