-
Level 2 - Sprint 2 : Activity 2.3.9.2 Update Historic Volumes for Baseline Forecast
Hi, In this activity my formula is IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET(Volumes, -52, 0) ELSE 0 . My result is 0, I don't know whether it is right or wrong. Can somebody please confirm this. Attaching the screenshot. Thank You very much.
-
Formula help on counting a Text LI
Hi, Need help on how to count the number of times a Text dimension LI shows up under a List LI. We have tried to use the SUM function as well as LOOKUP function, but they did not work. For Ex) We would want to know how many "Merchant Id's" are under each individual 'Legal Milestone" Below are snap shots of the two line…
-
Import and export data treasure hunt
We're restructuring the Import and export data section of Anapedia, and we'd like to find out if our new structure is intuitive. Try our imports and exports treasure hunt and see what you can find! The exercise finishes today, but if you have a spare 5 to 10 minutes, why not have a go?
-
Adopting and Expanding in a Connected World
The vast benefits of Anaplan are both widely known and constantly evolving. The ability to impact a business plan at the click of a button, understand a decision's downstream effects, quickly navigate between detailed planning and elegant visualizations are all attributes that make Anaplan offerings second-to-none. How can…
-
add child to certain list members
Hi guys, i have a module dimensionned by a list, this module is published in the new ux as a worksheet with an action button that enters data. what im trying to ask is: is there a way to achieve this (pic) ? i have a flat list, parent hierachy = total.
-
SUM with Group Number
Hi I want to sum Orders with Group Number. The point is Group Lineitem is not formatted List, is Number Formatted. 1-Nov2-Nov3-Nov4-Nov5-Nov6-Nov・・・Group123123 Order100200300400500600 Odrer(Sum)500700900500700900 I tried Rankcumulate or Sum Functions, But I can't Solve this.
-
Filtering/Formula based Complexity
Anaplanners, Had a query that i have been stuck on: - I have a module dimensioned by Projects, a List with serial numbers 1-10, list formatted Line item (Project Phase). Ask is, Projects dimensioned as row headers, Serial Numbers 1-10 as columns, Project phase/ Line Item as selector. End User can select a particular phase…
-
Switchover and Current Month change
Hi, It would be great to have functionality for automatic update of cheking out the Current version as well as changing the Switchover month during the period shift. I was informed that it's no possibility to do it not manually. It can be done e.g. by the switch button or the opportunity to trigger it when the month…
-
Switch Statement Formula
Adding a switch statement formula to Anaplan to get rid of long nested IFs! This would assist in readability (and therefore maintenance) of complex formulae. Switch statements allow you to test a condition, and assign an outcome to each condition. For instance you may have want to test what mode of transport is being used:…
-
"Model Health" / Performance Dashboard
As an external Anaplan partner, we get regularly the question to look into the performance and structure of customer models to assess the health of a model and to find opportunities for improvements. I built for this a model that allows me to upload f.e. line items and gives direct insights on key areas like size, usage of…
-
New Model Experience - formula editing field improvement
I am sharing here one idea that would make the New Model Experience even better than it is now: Automatic formula indentation / keeping white spaces and new line hits in formula text It would be quite nice to be able to keep the formulas more friendly-looking and let devs to work with them easier. Colours in formulas made…
-
Standardise Zero Formatting between Modules (& Classic UX) and New UX
When setting number formats, the formatting should be consistent across Modules/Classic/New UX. Below, see an example where a material zero balance is formatted as a hyphen as selected. In the New UX, this appears as a non-zero value. The workaround is to round the output to zero, but Anaplan should format consistently…
-
Be able to navigate/refresh dashboards while processes are running by other users
It will be a lot more efficient for users to be able to navigate and refresh through the dashboards so at least be able to view the information even if other users are running actions or entering inputs. At the moment, the whole model freezes while other users are processing action or entering inputs. This sometimes may…
-
Job Aid: How to Use the New Model Search
Retail Team!! @VickiA posted all the New Modeling UX features in this post. Just wanted to show you where the "Model Search" magnifying glass is located. Took me a while to find it. It's terrific! Already used it to clean up one of my models - used it to search for line items used for filters that I want to change,…
-
Level 2, Sprint 3- 3.3.6 Activity: Test the Shipping Cost Formulas
Hi, I am struggling with updating the formulas of Confirmed PO Delivery and Confirmed Purchase order receipt. Regarding "Confirmed PO Delivery", I understand to replace OFFSET by POST, to push the data to future periods instead of pulling: POST(PO Submitted, -Final Shipping Time Weeks, 0). But I don't get what is wrong…
-
Level 2 Activity 1.3.4.2
I'm unsure of where I am going wrong. The task here is to populate the missing Regions columns with the parent line item from the 'Countries' file. I am mapping the following; column 2: country name to Target: Country Flat column 3: Parent to Target: SYS06 Country Details Line Items Perhaps, i'm not understanding the…
-
Cloudworks export date format timestamp
I would like to have the possibility to define the date format for exports to cloud storages. When you currently export files through Cloudworks you have the choice to tick/untick the overwrite file option. If overwrite is unticked Anaplan adds a timestamp in a worse machine reading format (e.g. <action…
-
How to find no of strings in a concatenated string
Hi Everyone, I have line items which is the concatenated string ex - 123,435,234,678,567,987 I would like to find no of strings present ie 6 Could you please help me with this. Thanks Tejaswini
-
Grid on dashboard
* Hi, in a module saved view, I created a grid with weekly time buckets filtered on about two years history and two years future.. On the NUX dashboard view, the grid starts from the first week, so 104 weeks in the past, and we need to scroll to the current week if we want to make changes in the future. I would like the…
-
Display Line Item GUID in Blueprint
I would like to have a unique identifier for every line item in a blueprint displayed either on screen or when I do an export as this will enable me to do more straightforward comparisons between models where the line item name may have changed but not the use of the line item itself. Currently I either have to a code…
-
Create a Roles List That Can Be Referenced in Modules
Having a Roles list that is auto-generated and able to be leveraged in modules would be very helpful. For example, in certain system/admin modules we assign read/write drivers on partiucular line items. Currently, the users list is leveraged to dynamically change the access via a formula and an import. However, having the…
-
Level 2 Sprint 2 2.3.10-Baseline Forecast for FY21
Hi, I checked the answers related to this topic but I couldn't find the answers. In the DEM03 Demand Forecast module, I have the Baseline forecast values for FY20 which is coming DAT03 Historic Volumes module. However, I don't have baseline forecast values for FY21. I tried to write if/else formula for it but it didn't…
-
"Average" is close to useless. Need to be able to automatically only average non-zeros
The average summary method and aggregation function [Average:] both include zero values when calculating an average. This makes sense but sadly means that in almost all scenarios the irritating workaround of counting non-zeros and then dividing is required. This costs line items (and therefore space), increases calculation…
-
Add ability to easily step through / run until X in a Process
I would like the ability to more easily step through the actions in a given Process. Often when trying to debug an issue with a given process, I need to step through the actions in the process to see how the data or views change mid-process. Currently, I need to search for and run each action independently in order to do…
-
Selective Access
Hello, My model consists of hierarchical lists, E1 Expense category, E2 Expenses. I created an input module with E2 expenses, time(months), Money spent (line item) as dimensions. I have applied filters such that user shall select E1 expense category(in user filters module) and input module shows E2 expenses of selected E1…
-
How to get Formula to display the time it is pulling
Hi, Need to know how to get a date to show for a line item that is dimensioned by time, but the module is not dimensioned by time. The formula is working correctly, but can only see the result in a subsidiary view. Need to know if possible how to get the result to show when the LI is not in subsidiary view. If this is not…
-
2.3.9.1 Import data into DAT03 Historic Volumes module - 9.3 Import Shipping Metrics
I am having issues with 9.3 Import Shipping Metrics. I'm not seeing why I keep getting this error. Please see attached.
-
Polaris Engine and Calculation Memory Consumption
Exciting news on the new calculation engine. I saw the memory consumption on data https://help.anaplan.com/616ee341-8a5f-4718-8c90-c82e34eca86c-Understand-sparsity-and-density , however how do calculations compare in consumption of memory? There is a 3x usage for data, but if I increase my number of cells, how does this…
-
Applying DISCO labels to Model Map
I would like to apply the DISCO-methodology to the Model Map. The most efficient way would be to label the Functional Areas to the DISCO. The model map could then be visually sequenced based on the DISCO steps: https://us.v-cdn.net/6037036/img/PLANS_DISCO_33530.jpg?small?v=1.0&px=200 This could improve the value of the…
-
Manage List Subset in Module
Hi, I want to use List Subset. We can import Boolean item to List Subset. But we can not input the formula in List Subset and can not make a refference in module. How can I manage it in module and List? And Can we filter original List by List Subset?