Modeling

Sum calculation not visible when highlighting cells in expanded view
Currently in an Anaplan dashboard, if you highlight cells, you can view the summation of the values (see image below). However, when you expand the table to fullscreen, the summation does not show (see image below). We kindly request a product enhancement to allow for summation calculations in an expanded table view.…
How can I get the average of months for prior year?
I would like to get the averages for a line item using prior year month values. I can use the formula below but I don't like the idea of hardcoding. Is there another way I can do this without hardcoding? The current formula I have is: LAG(<source LI>,12,0)+LAG(<source LI>,24,0)+ LAG(<source LI>,36,0) / 3
7.2.2 Activity Errors
Hi Team, I am having issues getting the P2 Product family to accurately fill after uploading the CSV for activity 7.2.2. I have some photos below, I am assuming it's due to the P2 Products having All Products - Choc, sourcs, taffy, fudge? Any thoughts? Thanks!
Ability to repeat actions inside a process
I think it would be beneficial to have the ability to repeat an action inside a process. Currently, you can only add an action once inside a process.
DYK - WEEK 15 (Workflow)
Did You Know? That * Workflow allows admins to track the status of work/inputs on list item level and it also allows admins to communicate with users via email. Admins can send E-Mail to Individual Users or to entire User base (provided all these users have write access to at-least one list item) * Anaplan Workflow cannot…
Hierarchy Filtering Logic
Hi, I have a composite list hierarchy as below: Department L1 Product L2 Project L3 In a properties module, using this hierarchy. I got a Boolean line item named “Project?”. I can set up a formula to populate “Project?” as true at Project L3 Level. Let say I have a line item named “Product?”. Is there any way that I can…
SYS07 Sales Rep Details (Length of Service List Line item)
Hi, having trouble to find out why some of the result are blank Thanks, jehular
Filter by page selector
Hi, I want to Filter List by page selector. I have this two tables. Region List is a parent of Country. I want to achieve this below image. When I select Europe in Region table, Country table is filtered Europe Region. Is there any way to do this? I wish I can get List Item which I choose now.
Need Ability to Disallow NUX Toolbar Filtering, or Hide Toolbar Entirely in NUX
Similar to how we have ability to disallow native pivoting of a NUX grid by end-users, we need the same ability for native filtering via the toolbar. Prime example is that many of the would-be strong synchronized scrolling use-cases are negated by the fact that as soon as an end-user applies a native toolbar filter on one…
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?
NUX: Compound Sort
As a user, I would like the ability to sort multiple columns in a grid. I.E. Sort by Last Name, then by Salary, then by Hire Date. Right now i am only able to sort by one column at a time
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…
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
Timestamp using data write action
It would be nice to have it displayed the action run time stamp or a Boolean check timestamp using a data write action in New UX. we can bring by text formatted line item as we dont have time stamp data type. it will help to calculate several time related calculations. which will definitely help in several use cases.
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.
3.4.3 Activity: Create Country Summary Module
Hello, This is my proposed formula for the Flag Count line item - taking into account the mapping for both country and product family that are dimensions in the INV02 module 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Country Made In, SUM: 'SYS08 SKU Details'.Product Family] When…
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…
List property formula functionality to match module line item functionality
Hi Anaplan! It would be great if when you are entering a formula within a list property/attribute you can select another list item property by clicking on it instead of having to enter the name each time. This would also need to apply when referencing a modules line item, so clicking on the line item when a formula is…

Modeling

Discussion List