-
IRR Function
I am attempting to calculate IRR on monthly loan cash flows, but my results are different to Excel and make no sense (e.g. Excel give 14.7% and Anaplan gives 418.80%) . All the examples I have seen (on Anapedia and in the Formulas and Functions app from App Hub) have annual cash flows, for which it seems to work. I have…
-
Summary: SUM , Time Summary: Average ERROR
Hello, Is it possible to set two different summaries at a time? This is what I am currently trying to achieve in the following module, "Forecast - Cost per Layer" and "Actual/Forecast - Target Cost" line items: However, in both cases I get this error: Is there any workaround to this? Many thanks, Luca
-
Driver Line Item for UX Action Card - Not Working all of a sudden.
I've configured a series of UX action card with data write and Action runs driven by a driver line item . for approval workflows. All of a sudden the driver line items didnt seem to work and does not allow me to run the underlying process in the prod environment The Load invoice pricing card triggers an action run based on…
-
Optimiser for Minimising transport cost & transit Time:
Hi All, I've one situation where I need to build a optimizer which will minimise the transport cost & transit Time, Below are the details: Inputs : 1) Factory Supply Qty 2) Distribution center Capacity 3) Applicability of mode of transport from Factory to Distribution Center - Mode of Transport i.e by Air, By Road or water…
-
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…