-
Formula questions
Hi, I'm attempting to write a formula to pull in the percentage amounts of a line item in a different model in accordance to a certain vintage year. I'm trying to use either the LOOKUP or SELECT function but getting a error. Please advise. 'R01 Inputs'.Funding Scaler[LOOKUP:Vintage] Thank you
-
Breakback on List items
Hi All, I have a list product list P4 and a filter is applied on it i.e at P4 level only few items should be shown based on selection. Break back is enabled on all levels. In P4 5 items are there only 2 items belongs to category 1 and 3 items to category 2. Our requirement is that If user select Category 1 and enter data…
-
How best to create a variance module from a revenue module with a version dimension
Hi I need some help on this. I have created a revenue module with a version dimension for actual and forecast. The variance is a simple calculation of difference between the two. The issue I have is since the actual and forecast revenues are sitting in dimensions rather than line items, how does once calculate the…
-
How to get only one value from a module that contains Time
I want to get only one value from another module without having a list. The ideal is to display the value of the first month of a module with Time in another module that has no list. I am not good at English and it may be difficult to understand. Thank you.
-
Question on aggregations
I have a module with 4 dimensions - Version, Countries, Projects and Employees. Single line item is worked hours. Hours at employee, project and individual country level correct but not when aggregated at All Countries - the numbers don't look right, why? The aggregations seem fine at individual country level but not when…
-
First Virtual Group Event for Indian Modelers
Hello Anaplanners in India, Glad to share that we are going to have our first Group event on 7th April 2021 10:00AM IST. Register for the event here Group Event on 7th April 2021 10:00AM IST
-
Inventory Ordering Module Formulas
Hello everyone Why training course think that it is wrong formula? Confirmed Purchase Order Receipt (INV01 Inventory Ordering) IF Confirmed PO Delivery > 0 THEN OFFSET(Final Shipment Amount, -Final Shipping Time Weeks, 0) ELSE 0
-
Level 2 Sprint 2 DEM03
I am in the process of adding DCA's to DEM03 and I was checking my work against the example and my % growth rate is too high. It's at 14%. I checked the formula and it looks correct to me. I also checked my DEM02 model and it has the correct growth percentage rates in it. Does anyone have any suggestions about where else I…
-
Level 2 (2.3.9.2) Update Historic Volumes for Baseline Forecast
I'm having trouble creating the formula for this requirement: This is what i came up with: IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET(Volumes, -52, 0) ELSE 0 My model is taking this formula without error. This might be a silly question, but how do i check if this is correct? Here is what my module…
-
Space problem due to reporting
Hi, I have a calculation module that has 6 dimensions as well as by month. This one is then referenced by a reporting module without time (instead a list for MTD, QTD, YTD). The problem is that in order to get the numbers in for QTD and YTD I need to do a TIMESUM in the Reporting module, and since it doesn't allow…
-
Level 2 Sprint 1 Volumes and Has Data? Query
Hi Everybody, For some reason, in my Has Data? Query, I get this with the right formula, with everything true? To get my volume upload to work, I had to change both the module and the volume line to "week" from model calendar - is this the issue? Not sure what else to show, the figures look as per the following models, so…
-
Child and Parent mixed level formula
We've come up against an issue we're struggling to resolve. The situation is we have 1 Parent and 2 Children. We have the TotalStaff at the Parent level. Child 1 is prioritised and may require 60 of the staff to meet its SLAs - this is determined in a second line item. What we would like to do is be able to calculate the…
-
Summary Method - Multiply/Product
Hi all, I currently have one line item with 2 dimensions, and the numbers are percentages. I essentially want to **** out one of the dimensions in a new line item but to have all the percentages multiply by each other for the dimension that was taken out. In simple terms, I'm looking for a 'Summary Method' that multiplies…
-
Snapshotting Import Problem - Unknown Numbers Being Imported
Hello, An import I have is importing "mysterious", untraceable numbers into fields. I have a module with dimensions of time (month), B3 Sales Org, P2 Material. The line item I want to snapshot is "Sales History(Units) - LAG", with formula: LAG('Sales History(Units)', 12, 0) Sales History(Units) has no formula; its a line…
-
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…