-
9.2.6 Activity: Add Formulas to Margin Calculation Module
Can you please help? I coppied formula i think no issue about formula. Expected: Mine
-
7.2.3 Activity: Import Data into Employee Details Module
Hi Team, In the Level 1 Model Builder activity 7.2.3 Activity: Import Data into Employee Details Module , do we have to manually map mappings for E2 Employees between source and target items ? Is there any way for the mappings of E2 Employees ? Please help as it is very lengthy process to do the manual mappings for 111 emp.
-
Alternative to IF Historical Period? formulas
Hi All, It seems like almost every model I've taken over has relied heavily on something to the effect of: IF Historical Period? THEN Actuals ELSE Forecast I've seen some really **** formulas that have separate business logic for historical and forecast periods nested within the two conditions. Generally, this issue is…
-
Boolean Formula in List item
I have 3 level hierarchy Namely --- Country > State > District State and District has line items as properties namely Active in Boolean format i want to connect the two by using formula like if parent(district) = true then true else else is there any way to achieve it without using module?
-
How to avoid duplicate item with time (ISFirstOccurence)
Hi I want to make concatinate List. I have this table. Customer is determined by Product. Supplier is determined by Product and Time(week). Now I want to Customer-Supplier List. But in this case, I cannot identify unique key(Customer-Supplier Lineitem). So When I import to Customer-Supplier List, duplicate error has…
-
Tar 02 - PY Account Revenue
Hi - Not sure why data is not populating in PY Account revenue. Formula I am using is "'TAR01 Detailed Sales Targets'.PY Account Revenue[SUM: 'SYS03 Account>Product Details'.'A1 Account']" As the Dimensions for Tar01 and Tar 02 are different and I am mapping it through Sys03.
-
Level 3 - Read only cell error
Hi - I am not sure why below error is popping up.
-
L1 Model Building Exam - Activity 2, Need Help!
I am working on the L1 model exam and in activity 2 I'm confused about the mapping of the data.I think I've done everything right except for DATA02 SKU Volumes Line Items. I have no clue how to map that even though I know it begins on row 2. Can someone please help advise as to where I went wrong?
-
DEM03 Demand Forecast - adding Overrides exceeds size limits
Hi - working through sprint two of level two I am at the stage where I need to add three line items for the Override Forecast functionality, but cannot as this exceeds the size limits. The module uses the lists P3 SKU and Accounts, Timescale is Week and Time Range is Model Calendar. Total cells is 34,721,544. Perhaps my…
-
Level 1 Model Building Exam Activity 5 - Stuck!
I have been stuck on this activity for the past 2 days and do not know what I am doing wrong: This is the formula I tried for Bonus: For bonus: IF Employed? THEN Salary * 'EMP03 Employee Drivers by Role’.Bonus % [LOOKUP: 'EMP03 Employee Drivers by Role’.Department, LOOKUP: 'EMP03 Employee Drivers by Role’.Role] ELSE 0 And…
-
L1 Model Building Exam Activity 5 - Need Help!
I have been stuck on this problem for the past day now and have been unable to figure out where I am going wrong 😭 It says: In the EMP02 Employee Expenses module, update the formulas for Bonus, Car Costs, Phone Costs, Medical costs. Update the formulas to reference the driver data in the Drivers by Role module. The…
-
How to Connect Data Modules that have different Dimensions
Hi, I need advice on how to connect two separate Data Modules with different dimensions. I was thinking if there is a way to create a mapping module to connect them. They both have a similar LI's called Merchant ID. A screen snip is below of the two modules. Blue Print Common LI in the Modules Thank you
-
MB - L2 - S3 - 3.3.5.2 Inventory Ordering Module Formulas
Hi Everyone, Could you please help me to compete activity 3.3.5.2. I am struggling with the missing formulas in the screen shot. I will really appreciate if someone can help to resolve these formulas. Also please let me know if all other formulas are correct. Thanks JH
-
P2 Product and Product Platform Level 3
P2 Product and Product Platform is not populating any data, even though I tried to create Display name and using that in Formula FINDITEM(Product Flat, Display Name) and the message I am getting is " Display Name is not a recognized line item or list member Please advise. I am stuck here 😞
-
MB - L2 - S3 - 3.3.5.3 Check Your Work ( SUMMARY TOTAL - MISMATCH)
Hi Everyone, I am having issue with matching my work after putting formulas in sprint 3. All value are matching but summary totals are not matching at SKU level and All product level. Please advise what have I done wrong and how can I fix these issues. Please see the screenshot of my model against required numbers. SKU…
-
Rank function with Time
Hi, I want to use Rank Function. I want to rank "Num" with Location-Product. I input formula into RANK Lineitem. But the Rank function doesn't run. What is the problem?
-
When do I use SUM vs LOOKUP?
Determining whether to use SUM or LOOKUP depends on how the mapping table is set up between the Source List (where the original data resides) and the Target List (where the formula pulling the data resides). A mapping table between the Source List and Target List can be set up in one of two places: (1) in a Module, using a…
-
INV01 Inventory Ordering module - Shipping Method formula issue
Getting error when i am using below formal for Shipping Method in "INV01 Inventory Ordering" module , Tried so many ways but no luck can some one help me some thing is i am missed 'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)' [LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: 'SYS07 Distribution Center…
-
MB L2 Sprint 2 2.4.11.2 Create Account Demand Manager Role activity
Hi All, I am at the end of MB L2 Sprint 2 and working on the few last actives. Having some issue with 2.4.11.2 Create Account Demand Manager Role activity. Please answer below questions. 1. Why do we need to provide read access to SYS00 time module ( without providing access to roles to this module, the line chart is not…
-
1.7.3.2 Import into SYS08 SKU Details module
When I do my imports I do not receive any error. However no data is shown in the model. Am I missing something? My DataHub Model
-
Convert Line Items to Time Periods
Our Finance team requested we try to recreate this view in Anaplan for them to make their plans. We are struggling with how to show both the detailed info (vendor, department, country) and the time periods (Jan 22, Feb 22 etc) as single rows in the same table. Our best workaround so far is to include the time periods as…
-
Chrome default setting for Google G Suite Gmail to use with email link or MailTo
If you click on an email link or MailTo link and your Gmail doesn't open up in another tab, make sure that the protocol handlers in the Chrome browser is set correctly. This is what your setting should look like: If your email is not set to default to Gmail, make sure the "Sites can ask to handle protocols" boolean is…
-
How to extract data from a Line Item that has a Users dimension
hello!! Is there a way to extract data from a Line item that has a user dimension? The Line Item you want to extract does not have a Users dimension.
-
Formula to YEARVALUE with Actual months
Hi Guys!! Could you please help me with a topic? I have a module, where I need to calculate the average of my NET SALES for 2022, and that every month has the same value. I applied the YEARVALUE/12 formula and it works for Forecast months. However, for the current month, Anaplan brings me the Actual value and divides it by…
-
not a recognized line item
We are repeatedly getting the not recognized line item error when building out simple formulas sing line items all contained within the same module. In the screenshot below A-3 references A-1 + A-2 and all are clearly line items, this is happening when selecting the lines items with the formula editor and typing out the…
-
We'd like your feedback on the App Hub
Hi all, We are currently looking for Anaplan customers to participate in 60 minute research sessions.Sessions will take place remotely from March 2nd to March 11th. Participants will receive an e-gift card as a thank you for their time, if their company policies allow them to receive these. For this session, we will be…
-
Filter on Drilldown to only see items with data <> 0
Hello, I would like to ask if there's a way to make the drilldowns in Anaplan to only show items with data on them <> 0, or isnotblank? Currently, I need to scroll down a lot to locate to the account that has the relevant data. Thank you, Jonathan
-
Level 2 2.3.9.2 OFFSET formula
Hi i wrote this formula.It has taken without any errors but showing zeroes This is my formula IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET(Volumes, -52, 0) ELSE 0 Can u provide correct formula
-
Dynamic Cell Access by Role
I am looking for suggestions / alternative approaches for managing DCA by the user's assigned Role. Ideally, there would be an easy way to maintain this going forward. 1) I have heard a rumor that there is a trick wherein you somehow create a filtering module, then use the normal Roles>>Modules access assignments. Access…
-
Product list formula
Hi - P2 Product list has parent. Why formula is not pulling product family here?
