-
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…
-
Performance of Comparision of Boolean using = sign over using NOT function
Whether using IF Approved? = TRUE THEN 1 ELSE 0 is good or optimizing the formula as IF Approved? THEN 1 ELSE 0 where "Approved?" is a BOOLEAN format line item. Same goes for, IF Approved? = FALSE THEN 1 ELSE 0 IF NOT Approved? THEN 1 ELSE 0 Please advise to optimize performance of the model.
-
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…
-
L2 2.3.10 Wrong Value
Hi - I am at the L2 training segment 2.3.10. While my formulas are all correct (I think), I am somehow still seeing an unexpected value as an answer. Screenshots below on my formulas. I'm not really sure what's wrong here. Any help?
-
Formula
Hello, Quick question: How can I calculate the Volume between FY17 and F21 in the other module? For example, the difference between two years. Note: Just Volume is a line item. Please see the attached. Thanks, Mark
-
Behaviour of SEQUENTIAL parameter in RANK function
Hi All, We have a requirement to sequence items in a export and we've been using the RANK function to achieve that in a similar way that is listed in several posts in the community…
-
How to change date format DD MMM YYYY
Hi, I have a date formatted line item (example: 4/1/2020) - this is in mm/dd/yyyy format However, i want to show as 1 April 2020 or 1 Apr 2020. How do I do that?