-
Including Text within a Number Formatted Line Item?
Our client requests to see "no MTA" when MTA= 0 and Warehouse <> 0. However, instead of 'no MTA', I'm getting 'NaN'. Is it possible to include text within a number formatted line item? Formula - Final MTA = IF MTA = 0 AND Warehouse <> 0 THEN VALUE("No MTA") ELSE MTA
-
Update Codes in a numbered list
Hi there, the model has been in use for a very long time. However, it is full of dummy codes instead of the correct ones. Certainly, there is a lot of data associated with these elements. So I can't export change, delete the old elements and import the new ones. Is it possible to mass update the codes in a numbered lists…
-
Usage of First Occurrence formula with conditionals
Hello, I'm using the ISFIRSTOCCURRENCE formula to assist in creating hierarchies so the processes don't return a bunch of errors when generating the hierarchy, but now I'm facing a little issue, I want the first occurrence formula to return true only if other columns match some condition, but I can't find the correct…
-
Tell us what your teammates need from your dashboards
As an Anaplan user tasked with helping your teams better understand their data through your Anaplan UX dashboards, we want to hear more about what your end users tell you. What kinds of visualizations are they are asking you for, what do they struggle with in accessing and understanding your data, and how you resolve those…
-
2.4.7.1 conditional formatting add new rule option is not avaliable
Hello Can i know why I cant able to apply conditional formatting? why there is no new rule icon available when i select conditional formatting icon ? I have selected even a line item row or column and selected conditional formarting icon but still i there is no New rule option avaliable
-
Mission NOT impossible: Org hierarchy redesign for production deployed models
Author: Tiffany Rice, Certified Master Anaplanner and Tech Lead at Prudential. In a dynamic and ever changing business environment, it is inevitable that business requirements for forecasting and planning shift over time. Particularly in times of economic volatility we see companies leaning into transformation projects to…
-
Chart Data Labels - Show only one, and make font bigger
Hello - Is there a way to show only one of the data labels in a combo chart in the New UX? a lot of data labels are overlapping each other and it looks like a mess. I tried manually updating the scale, but then the scale doesn't look right when I make different selections. Being able to only have one data label would be…
-
Custom Date Format while exporting
Anaplanners Currently I have a grid at a day wise granularity. While exporting the grid the day is shown as follows: 1) As row header [here time is pivoted at a rows] - format comes as '1-Apr-2024' 2) When i bring it as a line item [with formula- ITEM(Time)] format comes as '4/1/2024' I would like to get a custom format of…
-
Charts & Graphs - The ability to set axis/axes as a Log Scale/Logarithmic Scale
There is currently limited functionality in terms of setting axes formats in Anaplan. As part of increased functionality, it would be great to be able to set an axis as a log scale as in the example attached.
-
Rolling Forecast Chart
Hello, Is there a way I can create a line chart that connects the Actual data and the Forecast? Attached is the screenshot from Excel that I plan to create in Anaplan. Thanks, Tom
-
NMX - Open App in new window
As a model builder and UX designer I would like to be able to open an App directly from the pages section of the NMX When I want to create new pages or review their order it is useful to review the current app(s) before proceeding. If a link to the relevant app for each page could be added to the NMX pages section this…
-
automatically include quarters and months when adding a new fiscal year
Hi everyone, I'm working with Anaplan and have encountered an issue with my setup. I've created a list with a parent-child relationship: Fiscal Year > Quarter > Month. However, I'm having trouble ensuring that each year contains the same information for months and quarters. When I add a new year, I can't parent the months…
-
Boolean Filter
This module consists of E2 Employee# list and 2 line items, one is to filter out the employee whose department needed to be changed. When I applied the filter and enable it all the unchecked line Items vanished. what I need is, when all is unchecked the list should appear and when one list member is checked it should…
-
Add XOR formula
Title says it all, a XOR formula would be really helpful and reduce formula length when trying to test an exclusive or. For those unfamiliar, here is the logic table for XOR. It acts as an OR however if both inputs are TRUE, then XOR returns false.
-
Using Optimizer for production line allocation
Hi, I am having issues using the optimizer for production allocation. The model is for capacity planning. Problem statement Need to allocate the SKU demand to compatible factory lines based on the following logic. Each SKU has a production priority and a factory line priority. * If the production priority for a SKU is 1…
-
Using LOOKUP and SUM with Formula summary method
A detailed description of the enhancement that is being requested. We would like to request an enhancement that would allow to use LOOKUP and SUM with Formula summary method. Currently Anaplan doesn’t allow to do so, although in many cases it is needed and doesn’t break the math. If available, could you please provide a…
-
Looking for AppHub users to participate in a user research study
Anaplan's User Experience Research team is looking for model builders with experience using the App Hub to participate in an upcoming research study. In this study, you will discuss your experiences with App Hub and Partner Based Solutions. This study will take place between February 7th and February 11th, and the sessions…
-
Makelink Length Constraint
Hi, I'm trying to link through from Anaplan to a Power BI report which has pre filters applied based on Anaplan context, so that the user goes directly to the correct view. There are a number of Power BI filters baked into the URL that I've added in and as such the URL is over 60 characters. When I then do makelink("Click…
-
Anapedia in NMX now! (and some other cool updates)
Author: Kirill Kuznetsov is a Certified Master Anaplanner and Solution Architect at Planingo. Exciting news for Anaplan architects and model builders! A new Anaplan feature has just been sneaked, and I already love it! Now when you open the formula editor you can push the question mark (?) and search through Anapedia right…
-
Gantt Chart - Change processing display
Description: We utilize the Time dimension on our Gantt Chart, making adjustments like moving bars or resizing them. However, when we release the mouse click, there’s a brief period (typically 5-10 seconds for our complex model) during which it appears that the change is undone—the bar position reverts to its original…
-
Filter by table
Hello, I hope you're all doing well. I'm seeking guidance on implementing a filtering mechanism for a table on a UX page. I have a table containing multiple parameters. My objective is to enable filtering such that whenever I modify a parameter in the first table, all subsequent tables are filtered based on the selected…
-
Source Object Name refresh in Import Data Sources tab of Actions (Model Settings)
The Source Object Name in the Import Data Sources tab of the Actions section in Model Settings is a very helpful piece of information when tracing source module views used in Actions. Model builders normally export this information to an Excel output and filter on the source object name to check which actions are dependant…
-
Sorting - List Members
Is there a certain trick or a set of procedure to handling sorting list members. I can control the first creation of list and import the record in sorting order but how does future addition to the list should be done so that they are always alphabetically sorted. I notice that after the first load, newly added members gets…
-
Too many cells for ISFIRSTOCCURRENCE calculation
I Import a C11 list to 2 spoke models from Hub. I use the same DataHub and Same Hub Saved view to import into this list. However the import into list is sucessful for one of the spoke model but not the other. The saved view and the import definition is the same for both the spoke model. For one the process is completed…
-
Quarter to month
Hello ^^ How can I convert a line item formatted in quarters (e.g., Q4 FY23) to a line item formatted in months, displaying the last month of each quarter Q4 FY23 =⇒ Dec Q1 FY23 =⇒ Mar etc Thank you
-
how to copy a lIne item from a module to another one ( Text format )
Hello, I hope you're doing well. I'm facing a challenge and could use some assistance. I have three line item text formats in a system module, and I need to retrieve the information in text format from the same line item with the same name from another module. Here's what I've tried: I went to the target module and simply…
-
Show a "Used in NUX Pages" column on the New Modules View
In Anaplan Classic, in the old modules view, there is the column "Used in Dashboards" which informs of all classic dashboards using each module. This same concept is needed within the New Module View for New UX Pages, so that model builders can quickly identify all NUX Pages using a module. I know that the opposite is…
-
Quarter to Text?
Hello Community, How can i go from the line item Quarter ( Quarter ) to Quarter ( Text ) example : Q3 (Quarter format) to Q3 (Text format) Thank you
-
User access
Hi friends I need to publish a module to the dashboard, there are about 10 line items in the module. One user should only be able to see the first 3 line items where as other user should be able to see last 4 line items and so on. I need a solution for this problem. Thanks in advance.
-
Level 2 Sprint 3 INV01 Inventory ordering Boolean line items
Hello guys, I've noticed that my Boolean line items have stopped functioning somehow. It was okay when I first created them and stopped working when I added DCA. I checked the formulas and write accesses but they seem fine.... Any ideas?