-
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…
-
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…
-
Access to Workspace
How do I confirm whether I have access to workspace and if I have workspace administrator permissions?
-
3.3.5.2
Can anyone guide me as where have I gone wrong in this activity
-
Level 1 Activity 4
Employee Details csv is clustered and not showing up in columns.
-
Christmas Brain Freeze or Summing from a module when you don't have time as a dimension
Hi, I have a module (SER) with simple data for a PO, value and a year period by customer In an invoice module (that does not have time as a dimension) i want to see the total value for that customer for the year. The invoice items has a Year based on its posting date. SER.Value[SUM: SER.Customer] This gives me the total,…
-
Level 2 Model Building Completion
Hi, I finished the level 2 training and I have submitted my model(Tuesday, December 28) and I have completed the survey. However, I didn't get any confirmation or anything stating that the level 2 course is completed. Request to please let me know what are next steps i need to do to get the certification and have the…
-
How to learn anaplan
Hi I got workspace access of anaplan, please guide how to learn anaplan step wise.
-
Selective access
Can Selective access be applied in case of Dependent filter and list has not been considered in dimension?
-
How to get last day of the month
Hi everyone. I would like to get last date of the month when certain data is entered. Image: I would like to get only the last day of each month that meets the conditions. Item is List format. Please tell me good solutions. Best regards.
-
Level 2: Sprint 1 Activity: 1.6.3.3
Hi, I am unable to get the result as per the screenshot with respect to Create Saved View for Export (1.6.3.3). I gave Time dimension as Half-yearly only. But still the columns FY19 & FY20 appears in my module (DAT04 Distribution Center Parameters). Please find the screenshots for reference. Thanks in advance.
-
Submit Button
Hi Community, Is it possible to create a submit button either in the old user experience or new user experience in talent builder workspace (i.e Anaplan learning workspace) Thanks & Regards Badam
-
RE verification of line item formula from SYS01 Time Setting by week module
Hi , Please guide me if i used wrong formulae for below line item. Thanks
-
Submit Button
Hi Community, I need to build sales planning process, where region heads should be able to submit the once they are done with the planning process and it should flow to the CEO. As a part of it I need to create a submit button in the dashboard. Is it possible to create such buttons either in the old dashboard or new user…
-
Level 1 model building exam question 4
Hi, I’ve imported all the data on employee expenses with no error. However, when I want to see the medical costs for finance department, the bonus, car costs, phone costs and medical costs are empty. Attached screenshots of the formulas. can anyone assist me please?