Modeling

13.6.5
Hello! My view does not look like it should. Please help! :-0 Should look like: ;((((
Average Function Affected by Hierarchy
Hi, I have a module which calculates an average using this formula: 'DATA01'.'Hours'[AVERAGE: 'DATA01'.Job Code, AVERAGE: 'DATA01'.Date] I want to add a regional context selector to this module so that I can view the average separately for each region. I added Region as a dimension in this module and updated the formula to…
SELECT() For a list top level item
Hi All, I am trying to use SELECT to pull through the top level value so I can create a phasing profile to push a single value down a hierarchy. I thought this would be possible but I am getting an error saying that the reference is not recognised. How have others managed to achieve the same outcome?
SUBSITUTE PRODUCT
Dear Community, Hope you can help me with this requirement; 1- In fact for a substitution of products, I want to display the first product on each line. 2- I want to display error message on this specific case (but not on the others). Thank you for your help
Notification : How to restrict address?
Hi, I want to use Notification Function in UX. I want a function that Member can mail to Manager. There are a function can select recipients by module. So, I tried to use it and make this List and module. List: Manager List & Member List ListManagerMember XA B YC Mail Module (from Member to Manager) Appliers…
Payment cut-off
Hi, question please. How can I calculate the payment cut-off which is happening every week. I have created a system module, screenshot below. Scenarios of the payment cut-off. 1. first cut-off - day 1 to day 7 >>> payment is after 5 working days (example: July 1 to 7, 2021 then payment day is July 14, 2021 -excluding…
Monthly Cumulate
Hi Team, Is there a way for me to reset my cumulate on a monthly basis? Thanks, Elaine
Totals position for formatted list items
It would be very useful to be able to adjust the behaviour of the totals when displaying a list formatted item. Within a module one can control where the parents appear; it would be good to give this option for list formatted items too. It is possible to "create" this behaviour using dependent drop downs or by activating…
OFFSET Value
I want to Offset values from dynamic day value. I hope the "Amount A" is offset to "Amount B like table. But the result was 0. 1/11/21/31/41/5Amount A 100200300 OFFSET 102 Amount B100300200 Result 00000 How can I solve this problem? When I use Monthly Offset Value, I could do it.
List item showing up in drop-down but not selectable
I have a list-formatted line item for which I would like to select a new item in the drop-down list. I can see the item in the drop-down list but when I select it, Anaplan does not accept the change and keeps showing the previous value. Does someone know what could cause this ? Thanks in advance.
XOR for versions
The lack of summary for versions made me create this formula: I am trying to get a functionality to have a boolean checkbox which will be FALSE for all other versions, but the one I have selected for the same time period, else - all TRUE. Time periods have this "All periods" summary which can be used in SELECT. Do you guys…
Add previous day records; delete Earliest Date records; retain max 5 days of records in a module
I have a module in which I import #rows of data for previous day I want to hold only 5 days of data. Everyday I want to delete earliest date #rows to ensure I hold only 5 days data Appreciate your input.
Calenday Days
Hi, For your assistance please. How can I mimic the calendar in anaplan? my time period is Days but I need to get the specific weekdays equivalent (Monday to Sunday). I created a list of Monday to Sunday and just have a drop down list...how can I do it automatically in the formula? Thank you.
Using NUX forms can cause rollback on duplicate code input
Hi all, Our team is in the process of converting from legacy/old dashboards, to NUX and one feature that holds a lot of promise are the NUX forms (for the purposes of adding to lists). The old dashboard style made it a bit clunky for creating new list items with controls and prerequisite inputs, but the forms are…
Use workflow in UX
Hi, I want to use Workflow in New UX. In New UX, We can not display "List" and chose the status. This restriction says that we should use DCA?
Import Enhancement: Tab- Line Items: Being able to select Multiple, All, or blank "Mapped to"
Currently when Mapping a file, view, or similar, if you have extra line items/columns, Anaplan doesn't always identify that a new line item is selected, and takes multiple attempts to have your selection identified. (Bug, and I use Chrome with 90% zoom) Being able to Map everything you are going to map, then select all…
level 2 conclusion DEM04 Demand Saved View
Does the below screenshot look correct for the DEM04 Saved View? The directions say that the product should only have a Product SKU Level. Also, are we supposed to actually export out a copy of the saved view?
Use value referenced from a diff module
Hi All, noob here, just started my Anaplan hands-on journey today. Hope you can help me 🙂 I'm looking for the right formula to get value from a module to a different module based from an existing module data. Below I have two modules. Loans and Lookup Rates In Loans module, I have two line items called Term and Rates. I'd…
Add Show Imports/Show Targets to Modules
Please allow model builders to view, from the current module, a list of all of the imports to the current module and a list of all of the targets (i.e. imports that use the current module as an import data source). The current process of resolving import issues from a module is tedious - from the current module a model…
Remove a selective access by import
@Tomishand I recently needed to have the ability to remove selective access for certain users from a selection module and a model-to-users import. The documentation on Anapedia is not very clear on the subject so I thought I’d detail the steps here. We import the code of the items to add in the Read / Write though…
Development Practice
Do we have any Workspace to practice and develop models in Anaplan. I want to practice and Learn.
About Workflow
Hi, I want to use "Workflow" two times like this. Step1 : Demand Approve. Step2 : Supply Approve. This means, First Employee make a demand plan, and get approval from Manager. Next Employee make a supply plan, and get approval from Manager. The problem is when step 1&2 run together. Workflow has one flow, so I think I…
level 2 vilt - 7.3.1 Create Demand Forecast UX Grid Saved View
I can't seem to create a pivot view to resemble Grid UX Please see attached - view required and my view please advise ravinder
INV01 Line Item Formulas
Hi, Would like to know if my Line Items are correct. Please advice The Line Items are on the attached pic. Thank you
Bridging Versions With Waterfall Charts
General Requirement For a set of measures, end users want to be able to choose any two versions and see the calculated variances between them. They also want to see a visualization in the form of a waterfall chart that explains the difference between the selected versions. Problem Statement Let’s say we have a summary…
Region importing issue at 1.3.4.3 Update SYS07 Location Details Module LEVEL 2
Region importing issue at 1.3.4.3 Update SYS07 Location Details Module LEVEL 2 While importing the location.csv into the SYS07 Location Details module, the region part is not uploaded properly. why? because: It is the reason that region flat has 3 line items: AMER, EMEA, APAC. However the csv DATA file attributes the…
2.3.9.1 Import data into DAT03 Historic Volumes module
i am trying to run process 9 but i got this error can somebody please! help me
Which functions support "Formula" in the summary method.
Hello, Is there a list somewhere that shows which functions support "Formula" in the summary method?
How to create a time filter module
This article provides the steps needed to create a basic time filter module. This module can be used as a point of reference for time filters across all modules and dashboards within a given model. The benefits of a centralized Time Filter module include: * One centralized governance of time filters * Optimization of…
Add line item count for list subsets
It would be really helpful to see the count of list members that are included in a line item subset. The only way I can do this is to make a "Master" list with just the subset and a line item called "Count" and see what the total is, but this takes up unnecessary space. But it would be nice to simply go to the list, click…

Upcoming Events

Quarterly Platform Release Webinar
Join us for our Quarterly Platform Release webinar where we highlight the latest enhancements and updates to the Anaplan platform. In this session, members of the Anaplan team will walk through key capabilities released this quarter, explain how they support better planning and modeling experiences, and share guidance on…
CoModeler for Clear, Correct, Continuously Improved Models
This session focuses on making the model building process more efficient, structured, and less reactive. It covers how to turn business requests into clear updates faster, improve visibility into model structure and documentation, catch issues earlier, and make changes to live models with more confidence. Designed for…
Community Challenge Recap: Polaris Modeling and Optimization
In this Community recap event, we will cover the most effective techniques for module rebuilding and optimization with the Polaris calculation engine, based on the top solutions from our participants in the latest Polaris Community Challenge.
Analyst Agents for Clear, Contextual, Connected Insights
This session focuses on simplifying how users get insights from their data by reducing reliance on manual reporting and back-and-forth analysis. It covers how Analyst Agents can be used to quickly surface contextual answers, connect insights across models, and streamline how questions are asked and answered. Designed for…
ACE: Anaplan Workflow
Registration and events details will release closer to the event date. Join us for the third session in our Workflow Expanded series as part of the Anaplan Community Experience program. This session continues our exploration of Workflow best practices and builds on the lessons from the earlier events in the series. We will…

Modeling

Discussion List