-
Nested Axis Sorting
Hi I have a nested axis that I would like to sort. This is something that is not supported - but does anyone know of a workaround for this? I was hoping that if I hid the subtotal on each line item it would allow the sort, but it does not. If there is no workaround, I hope this is something that can be considered for the…
-
Management Reporting - Ability to Re-Size Side Bar
Management Reporting it does not allow user to Re-Size the side bar. The naming of each slide is capped around 17 characters. Users are not able to identify based on slide header if they have similar naming and long.
-
Export data from NUX with preserved conditional formatting
Would be great to export data with applied conditional formatting rules
-
Hierarchy Filter on a Charts
Hello all, I have a plant hierarchy with Region > Location > Plants. On a Ux Board I have published the sales achieved at Region, Location and Plant level. However, I would like the user to be able to select a Region on the chart and be able to see associated locations and plants only. Similarly if the user selects a…
-
Time related Question
Hi Experts, I have a custom dimension on Week I want to use the data from previous Week Suggest me the solution Thanks in advance
-
6.6.5 Activity: Add Formulas to Time Settings by Year Module
Can anyone explain why are we adding these formulas in the module?
-
Fiscal Year change
How to prevent data loss during the change of fiscal year. Suggest any ways.
-
Why is my import not working??
Hi everyone, I am trying to run an import and it is not working. Or rather, Anaplan tells me it worked wonderfully but it's actually ignoring the data. And I really can't figure why… I've used a csv file, I've mapped the dates correctly, but it is somehow ignoring the data. Any help welcome, please! Flavie.
-
Shouldn't this formula evaluate to True for the period below?
I'm wondering why the formula for "Actual" in the period "Jun 23" isn't evaluating to True for that top line next to the red #1 in my attached screenshot. The formula for that line item is [ITEM(Time) <= 'SYS01 Version Settings'.Full Month Actuals Through]. I would think that the less than or equal operator would evaluate…
-
Level 2 Sprint 3: 3.3.5.2 Shipping Methods Formula
In the Inventory Ordering Module, I'm trying to use the below formula for Shipping Method:- 'SYS07 Distribution Center Details'.Default Shipping(LOOKUP : 'SYS08 SKU Details'.Supplied By)But I'm getting an "Invalid Formula" error.'SYS07 Distribution Center Details'.Default Shipping is list formatted to "Shipping…
-
Undo Function in NUX
Can we have "Ctrl+Z" or Undo Function in NUX like the way we have it in classic. Update from @davewaller: I've been working with Level 3 support to update this idea as there are some aspects of the undo functionality that have not been delivered within the UX, while other aspects have. * Undo of single cell, single value…
-
Uses of default versions or custom versions
What are the different disadvantages in using custom versions over Default ones.
-
Keep Source Number Format for Line Item Subsets
Would love for Anaplan to have the ability to keep the source format when doing a collect function. For example, when looking at a P&L report, Gross Profit is a $ but Gross Profit Margin is a %. When bringing values in as a COLLECT, would like those number formats to remain intact.
-
Enable Grouping Like Excel in UX pages
I hope to group like Excel in UX pages. Grouping function enables us to show/hide the line items easily without open the menu on the right corner of the grid. Thanks
-
List delete and Load
Imagine List A is parent and children are List 1 and list 2. List 1 and List 2 have same parent List A We need to delete and load So, where to start from is it from Parent or child
-
AnaplanClient.bat is not recognized as internal or external command, operable program or batch file
Hi Team, Could you please, assist with this problem? @echo off rem example. Set AnaplanUser="example@example.com:password" set WorkspaceId="*****************" set ModelId="*****************" set Operation=-via http://example.net:10085 -export "Export_action.xls" -execute -get "D:\output.xls" rem *** End of settings - Do…
-
Regarding the versions
when we want the Actual version data of particular line Item to replicate into forecast version without using any formula or switchover.
-
What is the impact if List subset and List are used in same Module.
For example: If a list subset say Pharmacy? which is subset of larger list Stores are together used in sales planning module. Aware that it cannot be used. However keen on knowing what would be the impact.
-
assets & Predictive Insight Modelsin anaplan
Where can we sue this option of Assets and predective insight models in anaplan
-
The importance of a Runbook: The evolution of model documentation
Author: Marc Weinzimmer, Certified Master Anaplanner and Senior Manager at Lionpoint Group. We've all been in this situation before. You find yourself in a conference room, and someone asks, "What documentation do we have on our monthly process in Anaplan?" Panic starts to set in as the room falls silent. The truth is,…
-
removing lists not required
hi If as list is not referenced by its settings can the list safely be deleted? ie not referenced in anything below
-
Actuals that change according to Versions
Hello, I am facing an issue regarding Versions, and I was wondering if there are new ways to resolve this. I have looked into this thread, but it is from 3 years ago, so I was hoping for an update on the matter… I figure I can’t be the only one.…
-
XIRR Formula
Hi, I am trying to use the IRR function in Anaplan. I have a dummy list of cashflows, with the following dates and net cashflows. In excel, I would just use the XIRR formula on cashflow date and net cashflow, but in Anaplan, what is the best way to add the redemption value in the current period and perform the XIRR…
-
Expecting a logic
Hi Anaplanners, The setup is quite self explanatory . Rate% in the source module is a fixed set of percentages. It could be anything, the numbers shown above is just for the demonstration. Rate-Overlay in the Target Module is user inputted field. User is supposed to input the overlay numbers here. The yellow shaded field…
-
Stack columns chart with version comparison
Hi all, Let's suppose I want to compare 2 versions of some metrics, on a chart. How can I obtain a chart as follows? It is important for me to stack the "values", since it shows me the total of all values. In Anaplan, when we nest axis, the labels for x axis only shows a replication of first dimension applied in columns,…
-
Module view: Column Wrap
I would like to have an option in Module view to set width of columns so that the name of line item and data is visible. Similar to excel functionality where you can click on "Wrap Text" and it sets the width automatically rather than change it manually.
-
How do I take MAX value of weeks and use it as my monthly value?
To illustrate Module A in Model #1 has a weekly time dimension My goal is to take the highest weekly MTA number of a given month and bring it to a new Model that's dimensioned by months and use the MAX weekly value from Model #1 as my new monthly value in Model #2 MTA's time summary in model #1 is set to Max When I brought…
-
User Subsets
As a model Admin controlling subsets of Users would help with reporting and certain modules that are only required by a certain number of users. Currently the users list must be used as is so if you have a large user base, that could create very large modules. If there are specific reports that only certain users should be…
-
Not Able to Move My Page
I'm trying to publish My Page to the App but I don't have the option "Convert to an app page". It's meant to be the first option (from other people's screenshots), but mine doesn't exist. Also, I am a Page Builder too. Any ideas? I've tried everything and searched every 3 dot button
-
I have created a ranked formula but when I go to sum the total it brings in the sum of all accounts
I am dimensioned across account, time, and practice. My formula looks like this IF Top Account Filter THEN 'Actual + Expected' ELSE 0. It seems to work with out a time dimension.