-
Excel Add-In and Anaplan Versions
i'm new to the Excel Add-In for Anaplan. If I point an Add-In model at cells in a particular version, say 'Working' and then deleted it, can I create another 'Working' version and will the pointers in the Excel Add-In still work? Gut feel tells me no, but I want to be sure. Any thoughts appreciated. Chris.
-
Dynamic Filter Dimension
Hello, I would like to build a filter where the user can select the dimension (list) by which they want to filter and then have another grid next to it where the selected dimension's members appear. Is this possible to have this flexibility ? Example: I have a module with the dimension "Orders" containing the sales of my…
-
how to decide the completed years(Length of service)
hi guys~ In Sales_Rep_Details module, What we know is the sale start date, so I calculate the completed years by: Start_Date_Current_Period(2020-01-01) - Start Date then I devide it by 356 the final formula is ROUND(('SYS01 Time Settings by Month'.Start_Date_Current_Period - Start Date) / 365, 0, Up,NORMAL) by compare my…
-
2.4.6.1 Create AD01 P3 by Account by Week Module
I don't understand why I have this on my AD01 P3. How can I remove it?
-
2.4.7.1 Create Demand Forecast Grid UX saved view
Hi, My line item is reverse from left to right. Any idea why?
-
How to stop calculation for a line item based on time selection
I have a module set up with weeks as the time dimension and covers a two-year timeframe. However, calculations are only needed for the user-selected quarter. To optimize performance, I'm looking for ways to avoid processing the entire two years. Currently, I'm using an If-Else statement, but I doubt it makes a significant…
-
What to map at REVO2 volume inputs
what to map here
-
Excluding Ticked Booleans
Within a list, is it possible to create a list subset based out of formula to exclude ticked booleans from other list subset of the same list?
-
Unable to import the data in p2 products list list
Unable to import the data in p2 products list list.I have downloaded the data and I imported it.But its showing errors
-
Dependent Dropdown
Hi All There is a list formatted line item in which the list is at lower level of hierarchy. I need dependent dropdown for particular items in the list without showing higher levels of hierarchy. Is there any possible way to achieve this by using the same list instead of creating a flat list.
-
2310 Create DEM03 Demand Forecast Module
Hi, I need some help for my baseline forcast formula, please.
-
Order list action not working.
For example, Module A has SKU list and line item POS which has certain data in it. Need to reorder the SKU list with respect to POS line item data in descending order (Highest to lowest). Used Order list action to sort the SKU list. The hierarchy of list goes by Organization > Model > SKU. Order list action. Module A…
-
what to set at the source and data values here? at modules
what to set at the source and data values here?
-
Current Year (time scale: not applicable)
Hello, How can I get the information contained in "current year - list" (year dimensioned) and put it into "current year"(non-year dimensioned)? Thanks in advance, Luca
-
L3 Model Building Sprint 2 - User Story 3.3
Hi Community, I was able to match my Target with the screenshot provided in the training. But after applying the commission and attainment % to Quarterly Target and then using Quarter Apportionment to divide quater values into monthly interval. My screenshot doesnt match the check your build. Commission% for Janell is 10%…
-
FIRSTNONBLANK not working
Hello, I am trying to use FIRSTNONBLANK as a function to get the current scenario to match to the current year starting from module dimensioned as month. SOURCE MODULE TARGET MODULE As you can see it's not working, why is it? Thanks in advance, Luca
-
Product Demand Allocation on Basis of Rank
Hi All, I've one scenario where volume needs to allocate by Rank. E. g. We have demand at Parent level i.e Product family level. Now in each product family we have different SKU's & demand should be get allocated by using SKU necessity in that product Family. Suppose , Product Family Level Demand = 100 and below is demand…
-
LOOKUP not working to change dimensionality of a line item
Hello, I am trying to change the dimensionality of the line item "layer yearly pt1" from: company, gr consolidation, scenario, year to: company, gr consolidation, scenario in line item layer yearly pt.2 My attempt was to lookup "layer yearly pt1" using a year to scenario mapping as in "WKK17 year to scenario mapping":…
-
Identifying New Items inserted in a List
I have a list of 'n' items and I run an import action on the list. The numbers of items in the list is now 'm'. How can I identify the items that were inserted in the current import. The import file can contain the items that are already present in the list as well. E.g : Initial List - 1, 2, 3, 4, 5 List after import - 1,…
-
What to do when Sync is incompatible?
When an ALM sync is incompatible, is reverting prod to last revision an acceptable way to fix the compatibility issue?
-
Model will not populate certain cells
Hi all, Ran into an issue when I opened up a future year in my model. For some reason the the module in the picture below will not populate data for the new year (2025). I've racked my brain quite a bit but can't figure it out, any chance anyone here could help me through this problem? I'm sure it's a silly step I missed…
-
Problem of inporting a List from Model to an other
Hello Anaplan Community, I want to import the same list from a model 1 to model B but I have this message that pops up every time. Can you tell me the reason behind this ? Thanks in advance !
-
Sum on dynamic filter selections
Looking for a way to sum off a data module based on dynamic user selections. My dashboard has a filter(dimensioned by user). Users select any combination of these dimensions(except amount and account). Sometimes fields are blank so a simple SUM wouldn't work. Ultimately the summation would live in a P&L statement so also…
-
Module with no dimensions
Is it possible to build a module with no dimensions that will allow us to import a file with thousands of rows? The current file we receive does not have a unique code. We would like to import this file into an ANAPLAN module and then create a unique code using the data in the line items so that we could then create a…
-
Adding lines of data from a list to a single line in a module
Hello all, Could anyone advise of an easy way to add multiple lines from a list or module based on my list to another module in a single line? So my list is a list of products, descriptions, etc and in the list-based module I have a boolean to select specific products, I then would like the list of data to appear in the…
-
Level 2 Sprint 1 1.3.10.3 Import Data into G3 Location List
Having trouble importing from a saved model. I've searched through the community for answers but still stuck. Can't seem to figure out how to get the column with the Boolean list. This is the activity and the end result: This is what mine looks like and the error I'm getting: Any help would be appreciated.
-
How can I get data to be imported to the next open row
I am trying to get a row of data to be automatically uploaded to a row that has not been filled yet. (I currently have it set up where you have to manually select the row every import) Also is it possible for the "ALL TRANSACTIONS" grid to automatically create new rows of transactions when all rows are filled? Here is an…
-
Training - Import Data into E2 Employees# List
Hello I'm having issues to import the data into Employees list. Instead of showing the employees names its showing a number with # in front of it. Could you please help me?
-
YTD Workaround?
I have an issue with the way Anaplan calculates YTD and need help figuring out a workaround. The YTD value in Anaplan includes the current week, which is NOT how I would like it or need it. i am in a weekly system and do not have actuals for the week I am in. So when comparing YTD Actuals against YTD Forecast it is always…
-
Trying to SUM revenue by account and product, getting datatype mapping error
I am trying to sum the revenue data in the "PY Account and Product Revenue" line item by account. Source and target module are both dimensioned by the same account>product combo list. I keep getting the same "Datatype mapping used for aggregation doesn't match any dimension of the result" error. Line item types are all…