Hi, I'm working on sprint 2, my model has successfully run action 9.1. the issue is that it's ignoring most of the data. Can you tell me if this is ok or should I modify something on the action import…
Hi , I am trying to import the details Level 2 - Sprint 1 : 1.7.3 Activity: Import from Data Hub to Supply Chain Model 1.7.3.2 Import into SYS08 SKU Details module Use the saved view from the Data Hub…
Hi All, Just wanted to clear some doubts on usage of SUM & LOOKUP at the same time for same line item If I use SUM & LOOKUP both at the same time for the same line item, its giving me correct details …
@noelle_murphy Hi, can I set up a 1:1 with you? Some of my formulas in lesson 6 aren’t working & it’s hard to move on from that. I also sent you an email. Thank you
Anplanners, I have a Module (XYZ) Dimensioned by GL (Row Headers), Cost Centers L3 as selectors and few Line items to determine the total amount. Aim is to get input at GL level for each Cost Center. …
Just wondering is there a way to find duplicates where the cell count is more than 50 million and I know in Polaris engine it is possible. Any other way to do it in the classic engine ?
Friends, need help & suggestion in achieving the below Above table clearly shows the Parent and Child combination but the catch is to consider own cost and child to show the rollup.. We have discovere…
When I want to Bulk Copy an existing version, currently I need to do two steps: 1/ Insert New Version 2/ Do the Bulk Copy In the first step, the system will create a new version that takes the maximum…
How would you use a select formula to collect totals for For example I want to fill the base opex row with numbers from this module below (totals only) What formula would I use? Thanks
Good Day, Quick question... At the end of the INV01 Export, it says: After completing the export file, the .csv file should look like this: How close should it be? Mine: Yours I just don't know how th…
error code received and i dont know why i entered CODE(ITEM('P1 Product Family')) received this message: 'P1 Product Family is not recognized as a hierarchy in the model The ITEM function should take …
I am getting an error message when I enter the formula for SYS05, anyone know where I might have made a mistake? Preview attachment IMG_20201103_212332857.jpg IMG_20201103_212332857.jpg833 KB
Or can there be a way to combine the data on the Actions tabs with the Imports tabs to pull an entire listing of my Imports and Processes? I am constantly copying and pasting data from the Imports tab…
Hello All, I've used the SUM function to map region and role into 'EMP02 Employee Expenses'. I've been going through my formula and the source modules for quite some time now yet the formulas still yi…
I keep getting an invalid parent error and then manually having to select the parent after importing. I now have a list with 400 that have to be mapped to the parent manually. I'm not understanding wh…
Hi, I have a question about filter function. I have two tables. First one shows amount by Location-Product List. The Second shows amount by Product List. Location-Product List has Product List as Prop…
Let's say I have column username where the drop down is a list. A username is "JonSmith-81". I'd like the next line item, lets call it alias, to just pull "JonSmith" from this string. The alias line i…
Hi @einas.ibrahim, Instructions provided in Activity '3.3.7.2 Add DCA to INV01 Inventory Ordering' seems confusing as both line saying that result show when Submit Purchase Order Request is NOT checke…
Hi , In my module highlighted values are different form the Anaplan provided screenshot. However the same values are matching with previous screenshot provided in the course. Please guide me on this.
Hi All I am having a module with a list(A,B,C...) and line items as given below. Update ,Text, Number are user input fields. Scenario: If an user checks update for C list item and updated text , numbe…
Hello. I'm stuck on the conditional formatting for the Final Forecast line. I noticed that my formula for the line item forecast cf only results in 0 no 1's, I'm not sure how to fix this as my conditi…
IF 'SYS09 Version Details'.Forecast? THEN 'EMP02 Employee Expenses'.Employed?[SUM:'SYS08 Employee Details'.Country] ELSE 'DATA01 P&L Actual and Budget'.Head Count+'DATA01 P&L Actual and Budget'.Head C…
A description of the enhancement required: To move beyond the statistical forecasting model from Anaplan, additional functionality of multiple non-linear regression analysis and ability to derive data…
I cannot seem to get this formula correct for shipping time in INV01: time in weeks for the default shipping method for each SKU. TRA01 contains shipping time in weeks, shipping method, and P2 Product…
