-
Level 2 Sprint 3 INV01 - Safety Stock Exception
Hello, Im currently in Sprint 3. When I was publishing the values to a dashboard, I noticed My Safety Stock Exception value was very high(Screenshot attached) On digging deeper, I found out my Ending Inventory values are negative for some months. Can this be the reason for high Safety Stock Exception value? I have checked…
-
Formula Box Auto-Resizing/Docking/Undocking
Having the flexibility to have the formula bar in the new modeling experience expended at the top versus jump to the bottom. In addition having the ability to move the formula bar around similarly to undocking and redocking so that the window has an auto-sizing feature when you toss it to the edges of your screen or…
-
List Item Count Reset Accessible via Anaplan Connect
Description: The ability to trigger the “Reset” action/button in the list configuration tab (for numbered lists), using Anaplan Connect to automate this process. Example of Enhancement: Anaplan Connect has an operation that enables reset of a list. And the index for a list can be reset without limitation (i.e. it doesn’t…
-
MAILTO Functionality Character Limit
Guys, I have this issue with the mailto functionality, wherein I am picking up user names for "TO" from the line item 'To', which is formula driven and is picking up more than 1 user. In a particular scenario the line item picks up more than a certain number wherein the character size of the line item exceeds the…
-
New UX Idea - Line item list selector expand width of the selection window
It will be very convenient to setup width value of a window where user selects a list item. Or to make it always be as wide as the longest list item name plus width of tabbed white-space due to hierarchy visualization. This is how it works in Classic UX: New UX is shrunk too much. The same problem appears in fields: Yes,…
-
New Modelling Experience Button Turns OFF in normal browsing mode of Google Chrome and MS Edge
The New Modelling Experience Button/Switch/Toggle turns off automatically if a user logs out and logs in again. This behaviour has been recorded in Normal Browsing Mode of Chrome & MS Edge. However, it does not seem to happen in Incognito Mode.
-
Line item reference to a member from SUBlist
Hello, I have a line item in my model - X with a list format. This line item uses the SUB list (as format). In another line item - Y I need to refer to a specific member from X , how should I do this? I have tried with the SELECT function, but I get an error because it is difficult to reference a member from the SUB list,…
-
Suggested Import Data Source
Would be nice if I could quickly select an import data souce when setting up new import based on the most recently created saved view. The suggested source item can be based on whatever the last source in the Import Data Source list is.
-
Schedule model-to-model imports in Anaplan as often as you'd like
Use the native capabilities in CloudWorks to distribute data from the Data Hub to Spoke models, or between different models in the platform, any time you want with its model-to-model import functionality. No activation, add-on services, or technical resources are required to use—everything you need to move data between…
-
Returns a date in the format date.
hi! Is there a function that returns each date in the format date? Or I would like to know how to implement it. Please help me！ idealized drawing:
-
User List in a module only assigns space to users who have access to the module
I think it would be a good idea if the user list would only create space for the users who are in a group with access to the module. In a scenario where a set of super users need to do their own variance analysis that involves lots of calculations, having all of the users who also don't have access to the module will lead…
-
UX idea: Pictures on published actions and processes
To make interface more user-friendly I propose to add ability to appy some images instead of action labels. Currently you can use emojis instead of an action label. But this means you are limited by existing emojis and they also can look diferent on different browsers and devices. Would be nice if we could choose an image…
-
Formula for a Line Item
Hi All, I'm having trouble figuring out the formula for this. I need to create a Formula for "A" for the succeeding months but the first month should be an input. Thanks!
-
Different Timescale/Version View
Hello All, I would like to create a reporting module as follows (in the screenshot). Is it possible to have a view like the screenshot attached? Please note I have versions in the model and timescale as well. Versions: Actual, Forecast, Budget 20 Actual, 21 Budget, 21 Actual this should be in sequence as per the report.…
-
Activity 8.8.4
I finished activity 8.4.4 but when I check my work (after changing filters to Americas and 100g), the numbers don't add up.
-
Weekly Calendar Setup -
Hi, On-time settings, as per the standard feature of Anaplan for the weekly calendar, the first and last date of the fiscal year is aligned with the last/nearest day of a month selected (Eg. Last Sun of Mar), however, is there an option to customize the starting and ending week of the fiscal year. For example, the first…
-
level 2 2.3.11.3
Saved View Name: Line Chart * Chart should show monthly Baseline Forecast and Initial Demand Forecast for two years. Hi Can anyone help me how can we set time for two years here is my work
-
2.3.11.3 Create Line Chart Saved View
* Chart should show monthly Baseline Forecast and Initial Demand Forecast for two years Hi How can we set the time for the next two years can anyone help please here is my work
-
Subset of LIS
Question: I have a requirement where I need to create two LIS for the same module. Assume Module has 4 line items (number formated) - Line item 1, Line item 2, Line item 3, Line item 4. 1st LIS will have line items(1 & 2) checked. 2nd LIS will have line items(3 & 4) checked. To achieve the above I will have to create two…
-
New Layer between Departments and Teams (Organisational structure)
Hi colleagues, I am a new user and very happy to be part of this community. I'd like to ask you a simple question having the need of a 3 layers organizational approach: - Is it possible (and in case, how to) to create a new organizational layer between Department and Teams? I would need to have L1 Departments (which group…
-
INCREMENTAL CALCULATION AND CONDITIONL FORMATTING
Hi guys, i need your help, im struggling with this, i will try to be as clear as possible . * i have this dashboard, column 2 is what i have now and column 3 i what im trying to achieve (i added the column 3 via excel). i would like to know if its possible to achieve the following setting in anaplan. the column 2 will be…
-
Staging modules
what is a staging module actually, I am having a hard time to understand it
-
level 2 formulas - offset, post, lead, lag
Hi There is some confusion in L2 regarding the above formulas In the class we used offset and post BUT not lead, lag; the latter two were replaced with offset and post. Is there use cases where Lag and Lead should be used instead of offset or post? There is vagueness here at the moment. Thank you ravinder.
-
Aggregation Calc
Hi, Is there a formula in Anaplan applicable to this kind of aggregations calc? Thanks Jayden
-
Filter for report
Hi, I have a module with a list of products with different ages. I want an end user to be able to select whether from a list to show all products < 3 years, >= 3 years and >= 5 years. In my module, I have created booleans to check for each of the above. I have also created a list for the 3 periods. I'm a bit stuck now -…
-
New UX: Dynamic grid update based on filter settings
As a model builder I want to be able to setup a Grid which will be updated dynamically every time after a user wants to reselect any line item published as Field or Grid which are used as filters, but without the necessity of reloading the page. Current behaviour allows to have the same effect, but only if the User list is…
-
Level 2 Sprint 3 INV04 Percentage Full
Hi, I am am stuck with trying to figure out the Formula for 'INV04 Distribution Center Capacity'.'Percentage Full' Line item. I can't seem to understand what all to use in it since it says: Can anyone please help me understand the logic and figure out the formula! Thanks in advance!
-
Lookup a Numbered List to find contract that falls within Date From and Date To columns
I have a numbered list with different pricings with different validity time periods (Date From - Date To) in months. E.g., Item A #1 Price = 1000, Date From = Jan 21, Date To = Jun 21 #2 Price = 2000, Date From = Jul 21, Date To = Dec 21 I have another module with time period in months and price in rows/columns, as well as…
-
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…