-
Level 1 Model Building - Lesson 8.6.4
Hi Community I have included the formula as requested into the formula line of Revenue however it's giving me the attached ERROR MESSAGE which I can't seem to rectify. Any assistance regarding this would be greatly appreciated. regards
-
New function to calculate 'Inception to Date'
It appears that there is no out-of-the-box function to sum all values up to the current period to return the 'inception to date' value. A new function could be very similar to MONTHTODATE and YEARTODATE but calculate from the start of the time range up to the current period (potentially with optional offset arguments).…
-
Sum all values in a time series up to the current date
Is there a way to use TIMESUM or MOVINGSUM to sum all values in a time series up to the current date? Essentially creating an 'inception to date' calculation. For example, if I have a monthly time series with the values 1,2,3,4,5 then I want my inception to date calculation to return 1,3,6,10,15. I can achieve this by…
-
How to perform activities while starting as a beginner with no application on the system?
Could you please help how do I get to access the application hands on for practice and further to perform activities to answer the exam questions through my system LIVE. I'm a beginner trying to give L1 exam. I have completed entire course theory with certain practical activities yet to be practiced. Any help is highly…
-
How to use SUM and LOOKUP dynamically
I have Order module(Region, Order) Order(1,2...) comes from each Region. Order has Item and Amount. I want to aggregate item-amount by dynamic Region like this table. If Users chose the Europe, Item-Amount Table is aggregated by Europe. I tried SUM and LOOKUP but I couldn't. The point is I don't need Region List in…
-
Formula Logic Help
Hi guys, Got a question I need assistance with. I have a number of lists that follow a hierarchical list, account level 4, 3, 2 ,1. At level 4 each account also belongs to an accounting group (online, local etc) and has a signage value of either 1 or -1. The accounting group and signage are contained within a module called…
-
Formula - What am I doing wrong?
-
Best Practices for creating a formula dealing with SELECT
Hi, We are trying to create a formula that will subtract the sum of all the List Items, (excluding List Item 'Other'), from the overall Total of all the List Item totals added together. We were thinking of using the SELECT function to pull in the amounts for each List Items and then summing those all together in a SYS…
-
Ratio of what % each child makes up of parent
Hello, I am attempting to calculate the % of a parent forecast each child makes up in a given time period. For example, a month has a 100 unit forecast in America. Texas makes up 60 units and California makes up 40 units (both children of America in a list). I am trying to show this: Texas 60% California 40% America 100% 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…
-
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)…
-
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
-
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…
-
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:…
-
"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…
-
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…
-
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
-
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…
-
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…
-
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…
-
Using Boolean Field to Filter
Hi. Currently the Retention (B8) field is returning the sum of all values. I've introduced a boolean field but i'm unsure how to update the formula so that it only returns the value we want (which is always the most recently added). There maybe a smarter way to achieve this?
-
Formula Help
Hi, Currently I'm trying to make it so if a end user puts in a number from a inputs model I created, then it will override whatever is there in the current month. The formula below is what I created so far but need help getting the input to override whatever was there for that current month. Formula IF End User…
-
select
when we should use select function . can anybody tell me with an example or scenario .