-
How to bring values in Length of Service line item?
Hi All, I am really struggling to bring values in the Length of Service line item. Since the module is not big I had first tried to manually select items from drop down for all Reps but I realized that it is not the best way. Can anybody please suggest something? Here are my model Normal View and Blueprint view
-
Import Action not working anymore
Hello, I have an import action that used to work perfectly well until today. It seems like Anaplan can't catch the module information. Here's the action: the action goal is to import the data from "previous mask" line item to "No of masks" line item: Here's the module view I use during the import: What's wrong with this…
-
Rank Cell Limit Clarification
Hello, I see there is a 50M cell limitation on being able to use the rank formula. I'm trying to clarify what I look at to determine if the line item I want to rank would be under or over the limit? For example, Do I look at the Cell Count of the line item I'm trying to rank or is it different? Second, I see in the…
-
getting errors in p2 products list
above are the errors
-
Today's Date
Hi, How can i refer Today's Date in a formula so as the values would change every day based on that days date. For e.g. if its 09th june then the formula should give result as 09th june . The next day i.e. 10th june the value should get updated to 10th june. Is there any such functionality or formula available inside…
-
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…