-
Error while using cod function in module
Getting error in sys02 region details module while using function Code i have attached error screen shot .please help me out on this
-
Level 2 Sprint 2 DEM03 line chart saved view
I am trying to create a saved view in DEM03. I have pivoted and filtered the data, but when I try to show only the Baseline and Initial Demand Forecast I get this error. I get the error when I select a row.
-
Level 2 Sprint 1 Import data into P3 SKU
Hi All, I'm trying to import data into the list P3 SKU . I couldnt find the view Build SKU in SYS12 SKU Details module though i have created and see it in the left pane Any suggestions Thanks
-
Help with understanding how Anaplan works
Hi Everyone, I am able to do the exercises but struggle to understand what is happening conceptually, given I am used to an excel world in finance! For example, with employees, at it's simplest: I would have a tab with all the employee details (name, start date etc), with a unqiue Key - then I would cross reference in…
-
4.6.6 Import Help
I'm trying to import the product.csv, but I can't seem to make it import properly. It's importing the product code instead of the name, which ends up leaving out important data such as the size and the code. Please help.
-
Filter using Selective Access on Line Item Specified as a List
I have a data set I would like to open to end user with a line item (Cost Center) set as a list(also cost center) with Selective Access enabled. I would like the functionality to filter the data set so that end users will only gain access to their respective Cost Center(s). I know the workaround for adding cost center as a…
-
Inputting a formula based on range of dates
Hi All, I'm fairly new to Anaplan and have a module that gets start period and end period. What I want to do is use these time range in order to set a specific amount based on a formula. I want to apply a specific formula on the time periods with respect to the start period and end period. To give an example, in one cost…
-
Level 3 Models - Time Settings - Should we consider the year as 2021 or 2020?
Hi, I started doing my L3 certification in 2021 and found that some of the data files provided in the training course had 2021 data while the Check your build sections had snapshots of 2020 model data. So I am confused about the time settings we need to use to build our models, should it be 2021 or 2020? I have completed…
-
Rounding issue
Hello, I'm having an issue in which a sum of rounded items is still showing some unexpected decimals. See screenshot below. Is there a workaround for this other than using formula as the summary method? Thanks, Josh
-
Error Message
Hi, I have a error message that keeps on popping up when I'm trying to create a formula. Please advice. Image is attached. Thank you
-
Summarize Boolean
Hi there, Module 1 has a model calendar, and module 2 doesn't use it. The model calendar has two future years & past years. I wanted to summarize the boolean of Module 1 in Module 2. I didn't get the expected result when I was implementing ANY & TIMESUM functions. Please advise me. Thanks,
-
Get code nex to list item in module dimensioned by time
Hi, I have the following module: Lists: E1 Employee Time: Month Versions: - Line Item: Salary I need a pivot with the employees as rows and month by column. All fine uptil now. But then I would like the employee code to show up next to the employee list item name. What would be the best way to go about that? If I add…
-
Smart Filter not working in NUX
Hello, We have a dashboard which features a smart filter for sales rep. When you select a name from the smart filter, the corresponding grid's selector only holds the accounts owned by that rep. This functionality is fully operational in the classic dashboard. However, when we imported that classic dashboard into the New…
-
Creating Formula Question
Hi, Would like to know how to create a Formula with the following structure for a Line Item (1). Closing Balance of Line Item (2) as of the end of the month, and this will show/happen only on the 10th of every month. My attempt END(Line Item (1) OFFSET( Closing Balance of Line Item (2), ?, ?) Please advise, Thank you
-
A way of determining redundant list items; list items with no data in any module
I'm looking to ensure my modules are as small as possible. In addition to other optimizations I would like to ensure every list item that is contained in some of my bigger reporting modules is needed. I'm defining 'needed' as there is some module in my model that uses the list it's within and has some non-zero value for…
-
Formula
HI, Have a module with assets and time dimension, some of the assets starts from the middle of the year. when on selection of total assets, The "No of payments" lineitem not showing sequential numbers and anaplan is not accepting(ss for the same) the "formula" summary . Below is the formula for No of Payments = IF…
-
Calculations using list items within a line items?
I have a line item that needs to reference one of the list items instead of a line item. What does this mean? I have a list of staffing types that use a model configuration to calculate based on what the user selects. Each staff type is mapped, then calculated off the drop selections the user picks. The main one is the…
-
Help with Level 1 7.2.1
Hello, I've tried a handful of combination with this import, but I'm just not grasping the mapping concept even after the tutorials. Could someone please help me match this up? Thanks
-
Circular reference
hi, have 3 lineitem, a, b,c wherein c= a+b, a = previous(c), b= a*rate of interest, But, however, getting a circular reference when writing a formula in the lineitem "b". Below is the screenshot of the explination, Any help is highly appreciated.
-
LISS changing look and order when using as Dimension
Hi, I created a LISS for my P&L but when I then use that LISS as a dimension for a reporting module it changes completely - see attachment for example. I've tried re-creating the module as well as another LISS from same source module but I still get the same strange result.. Best regards, Johan
-
sumif excel equivalent
Hi, I'm stuck on a sum select formula ?? Circuit Pull.Project[SELECT:Projects.X, SUM: Circuit Pull.Range] ?? Essentially what I'm looking for is to hard code a specific project below, project 2 but I can't figure it out in anaplan. Thanks in advance!!!
-
source and targert modules are dimensioned by two different dimensions
How can we link these EMP02 and REP04 modules to get total car costs by the region and role. When I am using formula i.e car costs = emp02 .carcosts[lookup: sys08.region, lookup.sys08.role] it is throwing folowing error. I under stand my REP04 is dimensioned by Region and Role where source module Emp drivers dimension by…
-
Creating formula question
Hi, How would I create a formula that would give me the number of days in a given month?
-
ITEM(LIST) help
Hi, I need some assistance. I have created a dashboard in the NUX with 2 separate modules. I've created a Product Type Selector (Product Type A, B ...All Product Types) which then filters on the module below for the user. This works fine. Separately, I have a table that summarises the performance of each of the product…
-
Way to limit or not allow user to select a specific time period in the dropdown
Hi, I have a line item Start and End that has a list of 1-5 as shown on the screenshot below. In the example below for item 1, I have selected start and end date of Jan 19- Mar 19, in item 2 I have selected Apr 19 - Jun 19. Is there a way to limit the dropdown of the second item so that it will not allow me to select a…
-
Get Total Value on another Line Item
Hi, Please help how can I get the total value of another line item to the other. Pls see attached screenshot where I tried to use lookup of the parent hierarchy to get the total value but it is not picking the correct value. Thanks in advance, Tom
-
Anaplan DocuSign Integration
Hi Team, Could anyone please share their experience in integrating Anaplan With DocuSign? Our use case is below - Users should be able to create Purchase orders in anaplan, Route for approval and track the approval statuses. Our Approver Business users are not Anaplan users. So, we need to create a PDF file using the PO…
-
Sorting within the archive
Just wondering whether there were any plans to introduce a sort / filter feature for models in the archive? We take copies to the archive regularly, and although try to maintain a common naming convention, the archive can be difficult to navigate around. It would be handy to be able to sort by date archived and name for…
-
Lookup Demo App
While seeing the Level 1 training, I came up with the LOOKUP demo app. But I couldn't locate it in the app hub. Where can I download it?
-
Formula for Time Period of Last Input
Hi, I have a reporting module that reports actual performance on 12mth, 3yr, 5yr basis. It is dimensioned by quarters and teams input information in relevant quarters e.g. Q4 2020, Q3 2020 How do I create a summary module that picks up: 1. Latest input quarter - I've tried LASTNONBLANK 2. 2nd latest input quarter (i.e.…