-
2.4.7.1 Create Demand Forecast Grid UX saved view
Hi, My line item is reverse from left to right. Any idea why?
-
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?
-
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?
-
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.
-
What to map at REVO2 volume inputs
what to map here
-
what to set at the source and data values here? at modules
what to set at the source and data values here?
-
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…
-
ITEM function in module with Line Item Subset
Hi All, I have a module that has line item subset as one of the dimensions.. Cost Center, Time, and Line item subset. The line item subset has three members, A, B and C. You can have input on them, however, C is the total of A and B. If it was a regular list, I would have the something like —- IF ITEM(LineItemsubset) =…
-
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
-
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
-
2310 Create DEM03 Demand Forecast Module
Hi, I need some help for my baseline forcast formula, please.
-
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":…
-
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
-
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,…
-
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 !
-
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…
-
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…
-
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?
-
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…