-
Converting inputted Date Range into new monthly module
Hey all, I need some advice here. I have a module (no time scale) where one of the attributes of a project is the start and end date (manual input as a date). I want to populate a new module (monthly time scale) with a 1 for each month the project will be active. Any recommendations on a formula to use to do this? Example:…
-
Write Access Driver to Parent Item
Hi, I want to use breakback function and Write Access Driver. We have Country List which has Region List as Parent. And Users input to "Adjust Lineitem" and it set as breakback. In this table, I want to users can write "Adjust" by Region List, and cannnot write by Country List. I want to set a Boolean Lineitem to Write…
-
Breakdown by proportional division
Hi, I want to use breakdown function. Breakdown has equal division function as default. (Image is Adjust(normal)) But I want to breakdown by History rate. case) Japan : 1000 * (200/800) = 250 Are there any way to achieve this by using breakdown function?
-
How do you build crediting modules?
Hi Anaplanners, Does anyone know how to build the calculation modules that would assign the business rules to the transaction details? My current method involves me building a boolean module to fetch the correct combination, and then creating views to import the "Sales Rep" to the correct transaction level account.…
-
Conditional Formatting on each Children
Hello everyone! I have a list with multiple children, and I want to apply conditional formatting (using boolean line item first) to each children at a time. How do I write a formula to select each children at the time instead of the parent? Basically I want to highlight every negative value for each sub list, but at the…
-
Error with Red Diamond Mark
Hi, I want to know the error shows Red Diamond mark. I often see this problem when input text or select List Items. What does it mean?
-
Day Timescale and Date formatted line item
Hi All, I have a model with Week General time settings. Module 1 uses Day timescale and Module 2 has Date formatted line item. How can I lookup line item in Module 1 using Date formatted line item in Module 2? The Day timescale in Module 2 appears as 10 Apr 2019 while Date line item in Module 2 appears as 4/10/2019. I…
-
Provide your thoughts on Anaplan's Excel add-in
We are looking for Anaplan Analysts and Report Builders to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of…
-
Formula to sum with condition
Hi, I need to sum the elements of one column based on an element "text" of another column. This text element isn't in a list so I can't use the function "Select". What formula can I use ? Thanks ! Best regards
-
3.3.5.2 Inventory Ordering Module Formulas - Beginning Inventory issue
I am getting the formula right - IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory However, I am not getting the desired results. I am getting IF and THEN part correct but i am not getting ELSE part correctly i.e., ELSE…
-
Display Status (Pending, In-Progress, Complete) in a Dashboard
Hi, I want to display the status of each dashboard in a landing dashboard. And i want it to look like the photo below: Can someone suggest their ideas with this? Thank you and Regards
-
1.4.3.2 Import Data & Add Formula in Sprint 2
I am not able to find why time is coming ? Please help , I am completely stuck.
-
stuck on level 2 sprint 3.3 activity
hello i need help, please !!! I am stuck on level 2 sprint 3.3 activities I don't understand why i can't have the same results that course My results My formulas Level screen reference
-
Create Shipping Export Module and Create a Saved View
@jagadishdash @alexpavel Can u let me know what's wrong? In the Supply Chain model, create a module to export the shipping costs by location and create a saved view for export: * Module Name: INV05 Shipping Export * Dimensions: G3 Locations list, Time (months) * Category: Inventory * Functional Area: Inventory Line Item…
-
Model Optimization
Hi Experts, I am trying to optimize the model size. Can you please suggest me the main ways to reduce the size. Thanks and regards, Mahesh
-
WARNING: App availability depends on referenced model existing
Yesterday, I refreshed our Dev and Test models from Prod to start a new development cycle. The Dev and Test models were actually brand new (only about a week old -- no in-model development, only App development) and didn't think I had any actual need to keep the previous versions since I was just looking to refresh data. I…
-
3.3.7.2 Add DCA to INV01 Inventory Ordering - first step
Hi there, In Level 2, Sprint 3, activity 3.3.7.2 Add DCA to INV01 Inventory Ordering we're asked to add Read and Write Access Drivers to INV01 - but in the previous activity we are only asked to to create three Write? line items: So should my first step after creating AD02 be to create three Read Only line items by putting…
-
Accuracy of calculations
Hello everyone 🙂 , we have two model builders who applied the same formula but with a different order, but since it's multiplication and division, the order doesn't matter. Unfortunately, I come across two different numbers. How accurate is Anaplan in calculations? Here an article i found Precision differences and large…
-
Create Shipping Export Module and Create a Saved View
Hello Community!! I am stuck at the above activity, can anybody please guide me what the mistake is?
-
Create Shipping Export Module and Create a Saved View
Hi, I need help regarding this activity. 1) When I pivoted the view during Module creation - INV05 , I have an error regarding the G3 'location - saying " No Items" 2) The formula for Code is 'SYS06 Location Details'. Code' , but my SYS06 module seems to be unuploded Can anybody verify and let me know the exact mistakes.…
-
Change default message process completion message to an error message/ LOCK button
Anaplanners, I have a process which stores the end user's inputs in the system. Currently users press the button without completing ALL their inputs thereby storing incomplete data. 1) I wanted to figure a way to lock the button when they have not completed their inputs AND/OR 2) At least throw an error message when they…
-
NPV Calculations
is there a way to calculation the NPV on a rolling basis? So basically I would want the NPV to be calculated on a quarterly basis for the current quarter and forecasted quarters. per the screenshot below, for Q4 2019, i want the NPV from the current quarter to Q2 21.
-
Version Formula in Module
Hi, Is there a step by step guide on how to use the Add version formulas to line item subsets in module blueprint ? I don't see any line item in the left box. Thanks, Tom
-
3.3.7.2 Add DCA to INV01 Inventory Ordering
Hi - I'm sorry, I'm really sure sure what the section is asking me to do?
-
Error Message
Hi, I have an error message that keeps on popping up when I'm trying to create a formula. I'm trying to multiply the two line items together. Please advice. Image is attached. Thank you
-
Boolean check box
Hi team , Can anybody let me know why can't my Boolean item have a check box ? Attaching the snapshot Guidance please!
-
Time Spread (Reverse Count from point in time)
Hi, I have a problem I am finding difficult to solve. Hopefully, someone in the community has encountered this before and can provide some clever solutions to this. First of all, the modules I am showing here are just to explain the problem I am trying to solve. The actual modules are on a very large data set so I need to…
-
Boolean format not showing check boxes
Hi All, As the title explains the issue, I am unable to see the check boxes in my grid view for a boolean formatted line item, can someone please help and identify what am I missing ? Please see the screen shots Any help will be appreciated. Thanks JH
-
Boolean check box
Anybody available to clear my query regarding why my Boolean Line Item does not have the required checkbox?
-
LVL 3: 4.6.3 Data Hub Model: SYS14 module
Dear Team, I got stuck in one place while building SYS 14 module, i don't have my old Data Hub model bcz of which i downloaded from training. 1) If it was DH model - then Data? has a simple formula to see whether SKU Filter system module has data and if yes then check if any Product is their 2) If DH is downloaded from…
