Modeling

Morse CF - Negative Formatting
Hey Anaplan, Anyone have a suggestion on how to use the morse conditional formatting to signify both negative and positive values are significant? Issue I have is that if I have: -50%, 0, 50% CF -1 (red), 0 (white), 1 (green) The problem I have is that -50% shows as a red dot, whereas 50% shows as a significant line. I…
New Modeling Experience Idea: New formula editor box to be avalilable in deployed mode
With newest UX for modeling I found the missing opportunity to see the pretty syntax highlighting in models being in deployed mode. The double-chevron icon is unavailable during deployed mode so i can't switch to "New intuitive formula editor so you can highlight syntax to improve accuracy and easily read formulas" which…
Ability to import a saved template card into Management Reporting Page
When creating a board or worksheet in NUX, it would be good when saving these as templates if the templates were available for import / use in the Report page for management reporting rather than having to rebuild them.
Report page : add card template library
it would be very helpful if we could have access to card template library when we build a report page, as it exists for boards. Report page : Boards :
OEG Best Practice: Time range application
If you have a multi-year model where the date range for different parts of the model varies (for example, history covering two years, current year forecast, and three planning years), then time ranges should be able to deliver significant gains in terms of model size and performance. But, before you rush headlong into…
New Model Experience: Not able to fully view formula bar when model is deployed
Hello, while I can open the formula bar in an ALM Dev model - I cannot do the same on any Test Environment (or the live environment). This is making very difficult to debug any issues on a deployed enviroment (need to check the formula in Dev which might have already changed) by another developer. Not too sure if this is…
Current Day
Actually we have a module that includes a column with dates, and we want that Anaplan identifies if a date from the column has passed or not yet. For that we have created a line item, and we would like the logic behind the formula to be something like this: IF the date (from the column) is prior to the date (current day)…
Most used Planning Models in an Organization
Hi Anaplan, @JaredDolich @Misbah @rob_marshall @MelanieM What are the most used Anaplan Planning models across different sectors, especially in the following domains: 1. Financial Planning and Analysis 2. Sales & Operations Planning So, will try to learn more about the same for execution. Thanks & Regards Badam
Remove the 'Edit' formula button within the new model building environment.
In a recent amendment to the new model building environment, there is now an 'Edit' button that needs to be selected before a model builder is able to amend an existing formula. This only appears when 'expanding' the formula bar. Whilst I could perhaps understand the reason for this addition in preventing…
3 months average of historical sales the year before
Hi, I need to calculate the three months average based on the historical sales data the year before. For ex: Jan 20 Feb 20 Mar 20 - Average values should go under Jan 21. 100,0,100 - 66.7 Jan 21 value Please could you suggest the optimal solution for the same? I have attached the screenshots for reference
Level 2 Conclusion Issue on Importing data DEM04 to DAT02
Hi Anaplan Community, I am facing an importing problem. Although I think I'm doing everything as it should, I get an error message every time. I have attached all the pictures and it can be seen that I must be doing something wrong with time mapping. But I couldn`t make it. I really appriciate your help. Thanks in advance.…
UX Text card - Font effects
This option is available yet for MR only. Would be nice to be able to apply most frequetly used font effects like (Italic, Bold, Underline, Strikethrough and etc.) to the text container in NUX. I have two options any of which will work. 1) Next to Edit icon in the top-right corner of the card 2) Above Title and Body text…
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…
Open source module link in NUX
Suggest to add the "Open Source module" ability to the NUX, incl. the current analysis options available in the old UX. Right now our users can use the open source module function in the old UX whenever they want to dig into the details, see all the underlying formulas/comments, and do ad hoc analysis. Especially, the…
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:…
Subset Formula in General Lists
Hi Team, Can we have an option to have "Formula" in the General Lists --> 'Subsets' section. It would be easy to control Subsets using formulae. Thanks Sathya
"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…

Modeling

Discussion List