Modeling

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
Actions tab -> Imports Tab -> Can we have the ability to export this data into an excel file?
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 into an excel file so I can filter and find the necessary imports and where they come from. Especially after…
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.
Invalid Parent Error
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 why this is happening and how to fix it. For context I am duplicating a list from 1 model into another and have set up the new…
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
Additional functionality of multiple non-linear regression analysis
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 set screening with statistical significance p-values, r-squared coefficients, and more advanced modeling as is being…
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…
Decoding Anaplan Errors in Model Building
Anaplan is a very smart and intelligent platform, and it educates its model builders/developers brilliantly about the mistakes or errors made. Here are some of the common errors that may occur while model building—decoded. ERROR 1: Automatic Sum of “Module.Line item” over “List hierarchy” is not possible, as “List” doesn’t…
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…
Configuring Write Access Driver by Drop-down
Hello, I am trying to configure the write access driver of an item to build something as follows: If drop-down item is selected, then the write access to a column is revoked. Else, you have write access. Can a write-access driver be configured to dynamically change once a drop-down item is selected? All the examples that I…
3.3.5.2 Question of Preference/Efficiency
Concerning the "Confirmed Purchase Order Receipt" field. The "Hints" suggest; IF Confirmed PO Delivery > 0 THEN OFFSET(Suggested Order Amount for the Month, -Shipping Time Weeks, 0) ELSE 0 That is working fine. However, I was thinking about using POST, as I do in the "Confirmed PO Delivery". Instead of using an IF THEN…
UX: Ability to remove hierarchy level shift in grid
That would be nice if I, as a model builder, will be able to diasable hierarchy level shift: Now I want to describe my problem. Suppose, there is a simple list with various levels in one: No parent hierarchy: This is required to have proper calculations on summaries. After selecting a module with this list appied on a…
Give the MB the ability to Report with a click when they hit an error.
REQUEST: give the MB the ability to Report with a click when they hit an error like this one. It would give the error logs along with the ClientSessionID.
Access to Workspace
How do I confirm whether I have access to workspace and if I have workspace administrator permissions?

Modeling

Discussion List