I have a calculation currently in the "Usage Base Forecast" line item. I want it so that if a user checks off the "Use Previous Month Final Forecast", it moves the final forecast from last month to ne…
Hi, I'm sure I'm having a blond moment. What's the easiest way to achieve the equivalent of this Excel formula/situation (Column F), in Anaplan ? Thanks!
Hi all, The use of the TEXTLIST() is not a best practice. However, as I go through the Anapedia, Planual and forum threads I haven't seen the alternative for that. There are some forum threads that pr…
Hello All, I have an issue where in there is table 1 with below structure: List (category list)Line item1 Line item 2DifferenceA11257A2410-6B11020-10B2633Total3238-6 And there is a table 2, which is a…
Hi Colleagues, Master Anaplanners. I've recently bumped in some complex calculations where I had to use different logic for different levels of hierarchy, most I've achieved through Ratio summary meth…
Hi I have a grid where in I need to calculate the average of the commissions selected for a couple of months and then to send it to another grid of a different month. How do I do it ? PFA screenshots …
I have a bar graph on my UX page showing headcount per month, but the chart shows the same data for all months when I've only loaded data for June 2022. I would like to see all other months show 0 unt…
I have a headcount dashboard with grid that shows employee name, team, region, level, etc. The end user will validate the information in the dashboard so I want to give them the option to filter diffe…
`Hi Team, I have a module dimensioned by Employee Roster and Time. In it I have a line item 'Train/Predict'. In this line item I want to add a formula such that if it's a past time period then Train a…
Hi team, Hopefully a straight forward one. I have 2 lists. Campaign and Show ID Multiple campaigns can have the same show however they are not within the same hierarchy. I have a module INP01:Campaign…
Hi everyone, I am replacing SELECT functions with LOOKUP as a part of model optimization (2.02-14 Avoid using SELECT). I did it lots of times and they worked but I am struggling with couple of them. M…
If you had already attended an event on 4th Aug 22 by "Modelers Forum India" you would be knowing by now that there is a concept called "Dimension Indexing" in Polaris Engine. In this article we will …
Hi everyone, I am currently building a project planning scenario analysis UX and have designs that use the line items "Month 1-18" to decide hours available by team. There is a button where we can "cr…
Has anyone used the "Organization" list models? Anaplan automatically creates it in every model which can't be deleted. I've never seen it used. I also don't recall any of the Anaplan courses use it. …
Hi team, Looking for help- i have a column with number format which shows currency value ( total) which takes FX rates into account as well . e.g $2,000,000 and so on... now i want to use filters whic…