-
Streamline hierarchy management with Polaris's new ITEMLEVEL and HIERARCHYLEVEL functions
Author: Dave Smith is a Senior Product Manager at Anaplan. In the world of enterprise planning, working with hierarchical data is fundamental—whether you're dealing with product categories, organizational structures, or geographic regions, the ability to roll up and see your plans at a macro-level is essential. Until now,…
-
how to SUM by native users, sku & time dimension all together?
I want to do a SUM from the source module which has native users, SKU list and time dimension to a target module line item by all users by SKUs. Target module only has a subset of the SKU list and nothing else. Need some inputs on how to build the mapping for the SUM. Is it also possible with the Anaplan native users list…
-
3.2.11.1 Create Planning Period Filters
Confused on which Line Item I'm building a formula for, I'm assuming both. Also this is the formula I used to so that the weeks in that month are selected as well when you select the month are as follows. Please advise. MONTHVALUE('SYS00 Time Settings by Month'.Planning Period Filter), Kind of confused why would not want…
-
not a recognized line item
We are repeatedly getting the not recognized line item error when building out simple formulas sing line items all contained within the same module. In the screenshot below A-3 references A-1 + A-2 and all are clearly line items, this is happening when selecting the lines items with the formula editor and typing out the…
-
Call Center Functions: Agents must return whole number?
Is there any equivalent or trick to returning 'fractionalagents'? AGENTS(w, t, y, z) will always return a whole number. My stakeholders are interested in both whole/fractional agent calculations.
-
Ability to exclude zero values from AVERAGE calculation
A common requirement we see on customer implementations is to be able to calculate the average of a set of values but exclude zero values. For example if we have the following set of values (10,0,0,8,0), the average excluding zeros would be (10+8)/2 = 9. The current AVERAGE function cannot exclude zeroes and so gives an…
-
RANKCUMULATE not working when adding additional dimensions to module
I have an issue where I am getting the expected result from RANKCUMULATE when using one dimension, but when I add an additional scenario dimension to the module, it doesn't calculate the way I'd expect. Here are some screenshots to explain the case: Module 1 - calculates cumulative total for list items in list "Age"…
-
1.4.3.2 Import Data & Add Formula
Can someone help me figure out what formula I need here? All the columns are filled. What am I missing?
-
Level 2 Sprint 2 2.3.10
Hi, as a result for the first question (2.3.10) I have the answer 71.34 but it should be 73.48. I don't seem to understand where I made a mistake. Could anyone help me out please? - DEM01 screenshot 1 (DEM01) - DEM02 screenshot 2 (DEM02) - DAT03 screenshot 3 (DAT03) - Formula: IF 'SYS01 Time Settings By Week'.'1st Forecast…
-
When deleting a formula from a module I would like the data in the module to also be deleted.
When deleting a formula from a module I would like the data to also be deleted/removed from the module. I realise the data can be removed manually by selecting the data in the module and pressing delete, but in a module with many thousands this is a time consuming process, particularly as Anaplan only allows deletion of…
-
Ability to select versions as a list formatted line item for use in lookup statements
Versions are useful as they allow switchover functionality enabling a user to both enter a forecast on a line and see actuals in the same line item. However, comparing versions to eachother (any version to any other version dynamically) requires a "Versions List" and logic to engage that list with the Version you want to…
-
Using time for something not time related - special characters :)$
We had a recent challenge with the need to "clean" invoice data descriptions from special characters. This was done previously in SQL with the a long convoluted formula "REPLACE(REPLACE(REPLACE('Ana&plan', '&', '') that would have to edited by a developer in case any new special characters came through. Using the replace…
-
Lookup error : invalid lookup list X is unused
Hi guys, I am facing an error for the first time and I was wondering if anyone had an idea on how to get throught it For some context I have : LI1 reference dimensionned by "Dimension A" format number LI2 target dimensionned by "Dimension B" format number LI3 dimensionned by "Dimension A" format "dimension B" (a basic…
-
Reverse BOM recommendation based on Attributes
Hi, Consider this scenario for a Diamond Industry supply chain Demand for Diamond from customer comes with various attributes [cut, carat, clarity, etc etc] Prospect has made over the years diamonds with various attributes. This historical data is available [both BOM and Recipe]. There is a unique Stage 1 BOM and Stage 1…
-
INV02 - Safety Stock Flag Count line item formula - Level2
I need some pointers to tell me what went wrong. 1) i created SYS08 SKU Details a column Country made in-----PARENT(Supplied By) 2) In INV02 i used the formula---- 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM:'SYS08 SKU Details'.Country Made In] but i came out the error below. I have P3 aggregated to P1 in…
-
AGENTS vs. AGENTSB
I am looking for some more background on the differences between these two functions. I understand that AGENTS takes into account the SLA and target response time, but where my confusion lies is moreso with AGENTSB. Agnostic to target response time, how does AGENTSB calculate # of servers based on a 'busy period'? What…
-
SUM and LOOKUP | Model Optimization Team series
Hi! Welcome to the Model Optimization team's monthly blog post. This is an eight-part series, following the topics we see occurring most frequently in slow customer models. Our aim is to inform and guide how to build with best practice intentions for these model building topics. Each month, two of our analysts will take…
-
Does the "Anaplan Formulas & Function" app still works?
Hello, Does the "Anaplan Formulas & Function" app still works? When clicking on "Download this app" I'm directed to a page "HTTP Status 400 - bad request". Thanks, Evrard
-
Regex Formula
It would be very helpful to include a regex style formula in Anaplan so we can pre-process text fields ahead of an integration, or even help to cleanse messy inbound text. Currently if we want to remove special characters, or parse strings into cleaner formats we have to specify one by one the characters we wish to remove…
-
Dimensions that don't exist yet
I need to dimensionalize a report in Anaplan by Regions we currently don't use. They aren't in Anaplan at all. We have the accounts we need but the Regions in Anaplan are different that the Regions needed for this report. I know I can create the Regions but the only issue is that I do not have the data needed to input the…
-
Filter a list by a selector
I have a page that has a list of sellers and a list of accounts. The list of accounts module has a line item of the seller. Is there a way to set up a filter with the accounts card to filter out accounts when I select a specific seller?
-
How have you from-scratch built lot-level, geo-based Inventory Consumption?
We’re working on modeling inventory consumption at the lot level, accounting for shelf life considerations, since we need visibility into which lots may not consume—both for risk reporting and E&O analysis. Each item may have customers with different shelf life requirements. For example, item A may need 270 days for some…
-
Calculation Effort column for Classic Engine
In the world of Anaplan modeling, performance is key. Slow model calculations can be a major bottleneck, impacting productivity and decision-making. But what if you could pinpoint exactly what’s causing the slowdown? Enter the Calculation Effort column — a powerful new feature designed to help you identify and address…
-
L2 Conclusion - REP05 Local Currency
Is there any issue with the formula for Local Currency? - Although it's fetching the correct result, want to check if there is anything else I'm missing. regards Sudhir
-
Using NAME with Numbered list
HI, I have a numbered list - 'employees' with the display name property set as Display Name. I have a system module called employee details dimensioned by employees list. I have created a text formatted line item in the module with the following formula NAME(ITEM(employees)). I expect to see the display name of the line…
-
Display Native YTD and YTG with a filter
Hello Anaplaners, I have an issue about displaying YTD and YTG in columns. In a dashboard, i display a module with native time in columns. On this module, we set up a boolean dynamic filter linked to a time filter module. This filter displays the current year (2017 in this case). But the client needs YTD and YTG in the…
-
OEG Best Practice: Formula structure for performance
Thinking through the results of a modeling decision is a key part of ensuring good model performance; in other words, making sure the calculation engine isn’t overtaxed. This article highlights some ideas for how to lessen the load on the calculation engine. Formulas should be simple; a formula that is nested, or uses…
-
Convert list to text
Is there a function to change a list value to a text? I want to use the & operator with list values, but it only accepts text. When I try just using the list-formatted line items, I get the error below, so it seems that if I could convert the list selection into text then I'd be fine: The 'text1' argument for the '&'…
-
Calculate once and reference | Model Optimization Team series
Hey! Welcome to the Model Optimization team's monthly blog post. This is an eight-part series, following the topics we see occurring most frequently in slow customer models. Our aim is to inform and guide how to build with best practice intentions for these model building topics. Each month, two of our analysts will take…
-
Kindly help me to understand how I can achieve this?
I have two modules. In the first module, when I select "America," its child fields should become editable. If I change the value of any child field from zero to a non-zero value, all other child fields under "America" should become non-editable, except for the one I modified. If I revert that value back to zero, all child…