-
INV04 Distribution Center Capacity
Hi My Capacity % numbers look weird, Am I missing something when calculating the beginning inventory. Pls refer to img. Appreciate your help. Thanks
-
Level 2 Sprint 1, Create a filter to show only half-years. (Hint: Use a system module)
Can anyone offer guidance as to how to create the filter to show only the half year view? (for 1.6.3.3 Create Saved View for Export.) I have this now: So in order to hide the FY20 and FY21 columns to meet the requirement, the hint is to filter using a system module. So i tried this: But this resulted in hiding all the…
-
Level 2 Sprint 1 User Story 4 - Time (half year)
I'm on Level 2, Sprint 1, User Story 4 and I'm stuck on creating the DAT04 Distribution Center Parameters Module. What's confusing me is the Time (half-year) dimension. Am I supposed to leave the regular time dimension in there when i create the module? Here's what i used, to no avail: I see that the data file for Weekly…
-
Identify Incorrect Amount
I am trying to identify if the amount entered is in correct format and also if it is Blank or not. In order to achieve that I am importing the amount in both text and numbered line item. - Below are the different results we get when we import the amount in different formats in text and numbered line…
-
Sorting date and override
Hi there, I need to sort by both the plan effective date (in reverse chronological order) and if an override was filled out. However when I click on the sorting I can only sort on the date line item or the override line item. When I sort on the date line item it ignores the overrides that do not have a date and when I sort…
-
Input data in a module published in a dashboard
I created a module with subset list as row and column line item named as assumption methods. Row Subset list are expense accounts while column line item are assumption methods e.g average YTD actual periods data , escalate YTD actual periods data or Input fixed amount I would like my module when published to dashboard to…
-
SYSY03 Account>Product Details (L3)
In my SYS03 Account>Product Details module, I can't seem to populate my P2 Product. Everything I have tried returns a blank - doesn't show any data. I wonder what I'm doing wrong. I've tried to getting the ITEM('P2 Product) = shows nothing.
-
summary method
Hi, question please. How can I sum up #transactions #1-#5 without adding the top list (alo world)? The total should only be 249 but the values is 5,772. I already edit the summary method to formula. Thank you.
-
Model Builder 2/- TRA01 Shipping Time in Weeks
Hi Been trying to figure out this formula but unable to due to the Year to week Lookup criteria . Any suggestions pls The formula for 'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)' is invalid: 'Shipping Time (Weeks)' = YEARVALUE('DAT02 Shipping Metrics'.'Shipping Time (Weeks)' [LOOKUP: 'SYS01 Time Settings By…
-
Level1 exam
I have no list with name All Roles but still getting error while putting it as top level in EMP 03 Role
-
Model1 Chapter 13 Price and Growth assumption Page
Please help 2 things different in my board and how to fix it 1.Margin Summary chart and Forecast periods grid have "US" and "Chocolates" in left hand corner but not in my board why? 2.My board have 2 times US mentioned in top right corner
-
Circular Reference for rollforward calc
I have a circular reference issue that I have not previously seen. The screenshot below shows a relatively simple example of a roll forward calculation where balances are carried forward. The issue I am having is that I would like the 'Out' line item to be dependent on the 'In' line item and simply take data from the 'In'…
-
Formula for Number or text
Hi, Is it possible to format a line item so users either input a number % or "n/a"? Thanks
-
Need help in setting the column
Hi Need help in setting a column up in our module. We have four separate columns , Cons_Last Month, Cons_Last Quarter, Cons_Last_Half Year, Cons_Last_Year, which are the numbers of past historical consumption quantity of a particular sku. For better presentation, we want to show all these under one column header '…
-
Level 1 Lesson 11.3.4 Activity: Add Formulas to Profit and Loss Report Module
Hi I have a problem in fixing the formulas for the above lesson. I have attached the screen shots for the first formula I was supposed to create which is for Headcount. REP03 Profit & Loss Headcount FormulaError message displayed for the formula Further, I would like to know whether the formula repeats itself for all the…
-
L2 Supply Chain Model DEM01 & DEM02
Looking for an opinion Is it best practice(DISCO) to have the following in a single module or is it preferred to have it in separate modules DEM01 & DEM02: Line 1 : Growth % by Month ( time set to month) Line 2: Growth % by Week ( time set to week) Thanks
-
Comparing List Items
Hello All, I'm attempting to do expiration calculation on lot codes based on a few points QTY in the lot Sell by Date Days on Hand When importing the inventory, we add 1,2,3 etc... to each line and use that as the code for the list. So we import the codes into the list first, then in the module it would look something like…
-
Consolidate Numbered List table
Hi All, I needed some help in designing a consolidation table for the input table as attached as image. i am trying to consolidate the Org Var based on CF Lines,Driver,Driver Groups for the fixed dimensions (in black). If i use these dimensions (CF Lines,Driver,Driver Groups) ,the model size increases to a huge extent. The…
-
Formula - Yes, no, n/a
Hi, How do I build a formula which states if a = b, then "not required", if a > b, then "yes", and if a < b, then "no". Thanks in advance
-
Pivot conditional formatting multiple levels - format selected columns
Hi Can anyone advise if it is possible to give conditional formatting only to the 1 of my column levels if there are multiple levels? I have the following columns: Level 1: account (sales and ebit) Level 2: scenario (act, bud, forecast, and variance to bud and forects It seems i can only filter based on account, so it…