-
Level 1
Hi I'm on question 6 of Level 1 and I keep getting this error. I've double checked my format and names and think they are right so I don't know why i keep getting this error Medical Costs = EMP02 Employee Expenses.Medical Costs[SUM: SYS08 Employee Details.Region2, SUM: SYS08 Employee Details.Role2]
-
NPV without an outflow
Good morning I am building a model consisting of future variable monthly cash outflows without any cash inflows. I need to calculate the NPV of that in order to convert that into a liability using the variable cash outflows as down payments.. The NPV formula require cash in and cash out. What are your suggestions?
-
Implement Slow Changing Dimensions in Anaplan
Hello I am facing a scenario where I need to implement Slow Changing Dimension ( Time Validity using Start Data and End Date ) for product & customer combination. A product can be sold to more than one customer. And the price varies over time for each of these product customer combination. I need a module to track the…
-
Linking Line item to List
Hello folks, I am new to anaplan and stucked at one small requirement. We are having two modules i.e. Module 1 - Product segment (Defined in List for different products) with transportation cost line item and Module 2 - Transportation cost for Each segment in line items (input). Need to know how can i link the…
-
Level 2 Sprint 2 DEM03 and DAT03
Hi Team, When reviewing my latest workings and forecast per DEM03 and referencing this against the example for the baseline forecast DEM03 in sprint 2, I couldn't help but notice that my figures are different for the future periods commencing in Week 1 FY21. I'm not sure whether this is related to an error in DAT03. Please…
-
Creating a new model - issue
I got stuck at one point in building a new module and I thought maybe someone could give me some advice. 1. I built an INPUT MODULE that has a lot of line items (about 30) - some of them are filled uploaded file and some are calculated based on other line items. For this INPUT MODULE data is loaded for two version…
-
User Dimension-User Filter
Hey, I have been stuck on a particular issue. I have a module dimensioned by list A. One of the line items is called "Approver", list formatted to a fake user list-subset. So every list item of List A has one approver of its own. In my second module which is also dimensioned by list A, I want to ONLY show the list items to…
-
9.2.5 Activity Error
Hi I am not able to edit 0 to 5% in unit cost %. Please guide what could be wrong here. Screen shot attached. Thanks -Pooja
-
User filter-User Mapping
Hey, I have been stuck on this particular issue for sometime now, wanted to check if someone here could help me out:- I wanted to filter list items of List A for the end user based on a non system users list subset. I have a module 1 dimensioned with list A, one of the line items in that are list formatted to a non native…
-
Defining levels on Ragged List
Hi team, Is there a method to define levels within a ragged list? I have a ragged list which is being used in a complex filtering exercise & for 1 of the conditions I want to only display the Lower level of of the ragged list (see screenshot whereby both Income and Profit & Loss are L1 but I wish to create a condition for…
-
SYS01 DEM03
Hi Team, I am struggling with DEM03 and the SYS01 Time Settings by Week Firstly, in SYS01, 1st Forecast Year remains empty, please see attached the blueprint of the same and the associated formulae as well as the time settings view. This in turn I believe leads to DEM03 Demand forecast to be empty for Baseline Forecast.…
-
Calculation Function - Minus Disposal Month
Hi Everyone, I need some help in building a model. So basically, from the above image, I have manage to read the Total Nominate TEUS for each month but I'm not sure How to: 1) let the system to know that, if there's a disposal in a particular month (eg. March and June) then the follow month (Apr and Jul in this example)…
-
9.2.5 Activity help!
I read a bunch of other comments regarding the 9.2.5 activity and tried to follow along to troublshoot the error I was receiving. however, I am still unable to find the root cause of the issue. I keep getting the below error. Can someone please help me in figuring out where I may be going wrong?
-
Boolean Filter Line Item
Hi team, I have a Filter module to calculate filtering at a row level due to some complicated requirements. There are 3 dimensions being: Location L3 SS: GL - EBITDA Report (L3 in Hierarchy) SS Channel - Budget Channels (No Hierarchy) On Level 1 of the GL dimension (List Item: Income) it is returning TRUE in the 'OPEX…
-
Calculation Functions
Hi , I'm facing an issue with the Selector in the below image . In Grid 1 , when I select Project Name = DARE , Product = Integration and Specifics = BU, I can see all other combinations as well which has these selected values whereas I just want to see the one highlighted below in Grid 2 . Grid 1 has List drop down line…
-
The page selector to show only the year
hi! I want the page selector to show only the year when the Time axis is month. What should i do?
-
selection control
hi! I want to create a module that allows me to select only some of the items in the pull-down menu. Example:I want User to be able to select only Apple, Peach, and Orange. I want to make it so that Fruit and Grape cannot be selected (not displayed). Can i do it? Please help me.
-
Revenue Formula is not working
Hello I am stuck here, not able to add formula. Error is unit price is not a valid item. " 'REV01 Price Book'.Unit Price is not a recognized line item or list member Thanks-Pooja
-
Lookup, Sum and Textlist Cheat Sheet
Hi all, During the last CPX in London, which was fun and insightful, came to my attention the fact that still now-a-days the most searched topic in Anaplan Community is "how to use Lookup and Sum". That is why I decided to share with you all this visual and brief explanation of how Lookup, Sum and Textlist work, I hope you…
-
Time - week ending
Hi, I have a module where teams are required to input weekly but at a specific schedule e.g. week ending 7th, 15th, 23rd, and last day of each month. Is it possible to configure this? Thanks
-
Parent and Ratio
Hi, I need a ratio along a list called 'P&L' I made 2 line items : * MyRef = PARENT(ITEM('P&L')) * ratio = Budget N/ Budget N[LOOKUP: MyRef] MyRef give the real parent of the P&L list. Everythings seems OK here. Ratio give zero (!) which is wrong by the way the forumula Budget N[LOOKUP: MyRef] gives 0 also How can i bring…
-
why isn't CurrentUser a command
Why oh Why can't we have a currentuser() command. I have spent 9 hours (and failed) trying to develop a filter module just to hide people who are not the current user from a grid on a New UX page. It should be simple, IF dataModule.mailaddress = current user() THEN TRUE ELSE FALSE
-
how to create boolean boxes for user to manually to check on
Hi, I have a list of opportunities and would like to create a Boolean column for user to manually check on. I would then like to filter the list where all the opportunities are being checked off (Basically to filter the list where boolean = true) It would be best if this can be done in the NUX where the user can check on…
-
IF statement help
Hi, I need some help with my formula - separately they are fine, but it doesn't quite work when I combine them together. In the consol I had initially just combined the formulas in A, B & C but it did not work so I then changed the formula slightly (see below). What should the consol formula be? Thanks AIF Line item A = X…
-
Variation Column that results "%" or "pts" in the same cell depending the account selected
Hello Everyone I'm trying to find a creative way to report the line items in rows and columns with amounts, variance $ and variance %/pts (the last in the same cell). In the screenshots below is the ideal formatting. Unfortunately Anaplan allow me to use only one Line Item, so I cannot create customized columns and be…
-
Pulling in data from a monthly module into a daily module
Hi, I'm trying to write a formula in a module that is time dimensioned as Daily, but the module I'm pulling the data from is monthly. How can I get data to come in. Basically I'm trying to break down the monthly information into daily. I do not believe a subsidiary view will work. Thank you
-
Calculation Query
HI. I'm struggling to understand why I am getting a zero answer on my pension row. Please see June 21 as an example.
-
Looking for a neat way to create a histogram in Anaplan
I am currently looking for a way to create a histogram out of a lot of simulated data I have created. Basically the application runs a full Monte Carlo Simulation and I would like to present a histogram of the Results. I have those results in a module with the "Simulations" list (lets assume it is all in one line item).…
-
INV04 Distribution Center Capacity Model: Beginning Inventory
Hi All, For some reason my Total Beginning Inventory in INV04 Distribution Center Capacity values don't look right. You can see my formula in the image below. It's basically saying my total beginning inventory is 137% of my distribution center capacity... Yet if I go to my DAT01 Beginning Inventory module, I can see that…
-
Formula that will allow me to divide a child by the parent
Hi, Need help creating a formula that will divide a child in a list by the parent. screen shot of the formula I have Looking to take the Amt from both Direct & ISO and divide them by the All BU parent from another module in their specific columns.