-
Level 2 - Sprint 1 - 1.7.3.2 Import into SYS08 SKU Details module
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 model to import into the Supply Chain model SYS08 SKU Details module. My mappings Import has been completed but with errors…
-
SUM & LOOKUP
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 as expected However, if, don't want to use SUM & LOOKUP at the same time, then what can be the options - * I tried with…
-
Formulas in lesson 6 not working
@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
-
Hierarchy Summary
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. I have a summary module (ABC) which is NOT dimensioned by any LISTS and simply has to take the high level total of the above…
-
Ways to identify duplicates for list import other than RANK or ISFIRSTOCCURRENCE?
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 ?
-
Rollup and SUM with own value
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 discovered a long method by introducing multiple line items (10 bare minimum; since the depth may be of 10 levels) but looking for…
-
Select formula
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
-
Level 2 Conclusion: Export Comparrison
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 they get the List field name in the upper Left corner, and the dates on the second row..?? Thoughts? Thanks again!
-
error code: 6.9.2 Add Formulas to Product Family Details Module
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 a hierarchy as argument
-
6.9.2 Add Formulas to Product Family Details Module
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
-
Level 1 Model Building Exam - Model Building Activity 6
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 yield 0s. Hope someone can help.
-
Filter by Property
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 Properties. I want to display these tables in one UX Dashboard. Then I want to filter the second table(Product) by First…
-
Modelling.
.
-
How do I get the characters before a specific character?
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 item is formatted as text. What would be the formula to return just "JonSmith" in alias line item? I seem to get an error due…
-
RE 3.3.7.2 Add DCA to INV01 Inventory Ordering
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 checked and checked. I think it could be no results when Submit Purchase Order Request is NOT checked and show result when checked…
-
RE 3.3.7.2 Add DCA to INV01 Inventory Ordering value mismatch
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.
-
Import data from one list item to other list items in same module(one to Many)
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 , number fields then the updated fields should import to the list item A,D as emp id and Emp Name are same. codeEMP IDEMP…
-
2.4.7.1 Conditional formatting
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 conditional formatting will not show blue if I don't have any 1's as a result. Formula - IF Initial Demand Forecast = Final…
-
Level 2 Sprint 3 - 3.3.5.2 Inventory Ordering Module Formulas
Can anyone please help me with the formulas for the line items attached in the screenshot ?
-
Does the "Anaplan Formulas & Function" app still works?
Hello, Does the "Anaplan Formulas & Function" app still works? When clicking on "Download this app" I'm directed to a page "HTTP Status 400 - bad request". Thanks, Evrard
-
level 1 exam activity 4
level 1 exam activity 1 entered 46000 still gives wrong answer?
-
RE Import Shipping Expenses into OTH01 Module
Hi , My import to L1 MB OTH01 Module from INV04 Shipping Export successful but seems nothing updated. Can anyone please guide me here? Thanks
-
I wrote correct formula but i am getting error?how to solve this?
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 Count
-
How do I get the characters before a specific character?
Let's say I have column username and a username is "JonSmith-81". What would be the formula to return just "JonSmith"?
-
Level 2 : 1.3.6.3 - Query
1.3.6.3 Create Build Location Saved View Create a saved view for importing: * Module Name: SYS07 Location Details * Saved View Name: Build Location * Include: Code, Parent, and subset line items Here what do you mean by subset line items Main model looks like In the Saved Model - Build Location I need to show all the…
-
3.3.5 Shipping Time
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 Products. SYS07 contains default shipping method and distribution center. SYS08 contains distribution center, SKU by code, and P2…
-
Formula Help
Hi Community , Can anyone help me describe how to use RANKCUMULATE function with an example , I understand the function syntax and all but I want to understand a use case of where this function can be used. Thank you!
-
"Use Switchover" & Version Switchover Change
Bit of a weird thing happened in a model today whilst preparing it for the next round of forecasting. Change the switchover date of forecast from Oct-21 to Jan-22... and 6 minutes of toaster time followed by an invalid line item message. Really quite weird, as this hasn't happened before - so I check the line item and the…
-
RE conditional Formatting in Level 2 MB Sprint 2
Hi , Please help me how to create conditional formatting for below. Thanks Abhishek
-
3.3.6 Changing OFFSET to LAG
Hi all, Having some issues changing the OFFSET function to LAG. Using the following formula; LAG(PO Submitted, Final Shipping Time Weeks, 0) My Final Shipping time in weeks is 1 for the PO submitted column, the lag I am seeing is however 2; The only way I can get the LAG to show up correctly is by checking multiple…