Modeling

Anything wrong with my formulas?
Hi, I was taking the level1 certification exam, creating REP04 Employee Expense Summary. Here are my formulas: Salary: 'EMP02 Employee Expenses'.Salary[SUM: 'SYS08 Employee Details'.Region, SUM: 'SYS08 Employee Details'.Role] Bonus: 'EMP02 Employee Expenses'.Bonus[SUM: 'SYS08 Employee Details'.Region, SUM: 'SYS08 Employee…
Help Replicating Excel Formula
Hi, Need help replicating this Excel Formula. The Anaplan formula we created is not working. Excel Formula =IF((WR20+WR26+WR27+WR29+WR28+WR5*0.95+WR31+WR32+WR35)-WR40>0,IF(WR29+(WR5*0.95)+WR31+WR32+WR28-WR35<0,0,WR5*0.95),0) Our Formula IF 'S01 Time Settings'.Actual Date <= 'S02 Time Admin'.Last Actual Day THEN PFR Value…
Control Weekly Seasonality
Hi. I have a question about weekly statistic forecast model. In this model, can we control the difference of weeks in another year? Suppose that, some food's demand will increase dramatically on 01/01(New Year). ・2014/01/01 - Week 1 FY14 ・2015/01/01 - Week 52 FY14 In this case, I think we cannot control the Weekly…
Trying to replicate Excel Formula
Hi, I'm trying to replicate the Excel Formula in Anaplan below. I'm trying to use the AND function, so i made two Boolean Line Items and combined them to satisfy the condition. The formula worked but no numbers are showing in my line item. please advise. Excel Formula…
Native User List Properties
Hi All, How can I pull the native user list properties into a module such as First Name, Last Name etc. Thanks, Chris
How to pickup value from a cell and populate next column
Kindly refer attached screenshot. Am trying to figure how does one populate the boxed column with the value in the cell (1,414). I am already able to do something by looking up a SYS table I constructed but the problem is I can't seem to figure out the right formula to use which should be to pick up the value 1,414 which…
Make data cells within a module editable
How do I make the below data cells within a module editable?
'Referenced By' Column in Blue Print View should expand or drop down to show full detail
Hi Anaplan, The 'Referenced By' column in the blue print view should expand or drop down to show full details. This would be really usefull as you can instanty see where a line item is being referenced if it has multiple references. Thanks, Usman
Dependent Drop Down on Multiple Criteria
It would be very helpful to be able to create dependent drop downs based on multiple criteria. Currently you can do either hierarchy levels or list properties but to help users filter more dynamically and spend less time scrolling through long lists, we should be able to make a line item drown down dependent on multiple…
New Modelling Experience - arriving 4th May
Available from 4th May, the new modelling experience will make the flexibility of Anaplan even greater and enable even faster and more intuitive development. Highlights include: * Enhanced formula editor, interface and navigation * Highlight and check syntax with the new intuitive formula editor * Open lists as discrete…
Line Items not visible
Hi - What have I missed in the build of this module? I can't see the line items outside of blue print:
Transactions by period - remapped to transaction list with no time period.
HI I have a line item which contains all the cashflows I require for the IRR calculation, but I need to have the cashflows against the last day of each period to get the correct IRR result. In order to do this I have created a transactions list "Trans 01, Trans 02, etc" and then for each of the projects created a line item…
Increase list character limit
Hi. How do I increase character limit?
Search a Hierarchy using Code, classic vs. NUX
Hello, I am noticing a behavioral difference between classic vs. NUX. In classic view, let's say I have a module that is dimensionalized by L2 Hierarchy x Line Items. If I have L2 Hierarchy as my page selector, and I have a list member with the code ABC_123, in classic I can search for this in the page selector and return…
Help required on MIN function
Hi need some help on the MIN function as I can't seem to get it to work even after going through the Technical Documentation. Attached at the relevant screenshots: SYS08 has the MIN formula I'm trying to get to work. The idea is to look up the MIN value in the # Accounts for Redistribution column in the TAR02 module by…
Level 2 Sprint 3 3.3.5.3
Hi all, I'm checking my work for the INV01 module and my numbers are slightly different than the ones provided to do the check. Here are my numbers below: Here are the numbers provided to check your work: As you can see, beginning at Week 2 FY20, my Forecast Demand is 2,048 and not 2,050. I'm assuming this has nothing to…
User based delete action
Hi I want to give a functionality to the user where they can select a Boolean (say basis state) and delete the data in a transaction list that are mapped to that state ( in a line item in the system module). see table: StateCheck to deleteA BYC D Since the user has selected the boolean for B, only those transactions are to…
Using LASTNONBLANK on a numbered list
I took over a Headcount model that was built by a consultant and it uses LASTNONBLANK on a numbered list. I'd like to confirm my understanding of the function when used on a numbered list. Here's some background on my particular model * Workday sends Anaplan an Employee file each night* This nightly feed from Workday…
Importing into Numbered List
Hi Team, I am facing 2 problems while importing into the numbered list from my Data hub model: 1) it's showing an Invalid Parent error. I have used Parent code while importing, Please suggest how to resolve this? 2) Even though import happens with error, the import list is adding below to the list where import should…
List Formatted Items Dependent Dropdown based on a Module Line item
Currently the only way to define a dependency for a list formatted item is to use a List Property or its natural parentage. I would like to maintain this relationship in a module rather on a list property as recommended in the current best practice guidance.
Limit user entry for Dependent formatted line item
Currently if you format a line item as a Dependent list, the user gets a dropdown of list items that correspond to dependent criteria, same applies if they are typing the value. However it is possible to copy a name of a list item that is in the list (but does not suit dependent criteria) and paste it without getting an…
Filters rows in a sequence
Hi, I need the rows in sequence even after applying the filter in the module. I have a transactions list which is a flat list and two line items Email address and ISnotblank?. I need only the non blank rows in a sequence. Generally when I apply filter the rows will be jumbled but I need the rows to be in sequence. Before…
How to Concatenate Strings with nested IF statements
Hi, I have four line items(Text1, Number1, Text2, Number2) I am trying to concatenate if those values are not blank or not equals to zero. See below formula. But I am getting formula invalid error. Please suggest how can i do concatenation of multiple string with nested IF statements. Note: Please suggest me any Idea with…
Anaplan Data Hub - Numbered vs regular list
I am in the process of creating a Data Hub, where we will be getting multiple files to create lists in the DH. I need to consider creating the flat lists as either numbered or regular list. For the lists which have member names longer than sixty, I would create a numbered list where I would make use of the Display Name…
Reduce time scale in imports
Is there any process by which I can reduce the irrelevant months in imports while uploading the file. I cant use time range here. Can I do this with the help of any filter.
Data Hub - Numbered List vs Regular List
I am in the process of creating a Data Hub, where we will be getting multiple files to create lists in the DH. I need to consider creating the flat lists as either numbered or regular list. For the lists which have member names longer than sixty, I would create a numbered list where I would make use of the Display Name…
Make the Roles->Lists Section Uneditable if the List is Structural List
We Know that the Roles->Lists Section need to be checked when there is a need for an end user to edit the list and the list here would mean Production List. Idea I am proposing is to lock down the Roles->Lists enabling feature for all Structural Lists so that WSA's don't get the option of enabling it. This way Anaplan will…
Error in 7.2.3 lesson invalid date
I gor struck while importing .csv file into SYS08 emplyee details module i am getting invalid format error .please help me out on this
Previous Period Lookup
Hi I have a module where I look up the last period with data entered - line item Previous Non-Blank. My formula is as follows - why in Q4 FY20 and Q1 FY21 is the previous non-blank not picking up Q3 FY20 and Q4 FY20? Formula: IF Last Quarter Entered = Last Quarter Entered[SELECT: TIME.All Periods] AND ITEM(Time) >= Last…
Apply Conditional Formatting only to Totals in a worksheet
Hi Anaplan community, I have run into the following conundrum - I want to apply conditional formatting only to the totals of my line items in a worksheet. Now, I know that this isn't possible out of the box as Anaplan applies conditional formatting on a line item basis; however, I checked out this workaround posted…

Modeling

Discussion List