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 edi…
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 t…
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…
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…
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 w…
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 m…
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…
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 r…
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 prop…
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…
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 blan…
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. Pl…
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 li…
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.
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 li…
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 Rol…
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 F…
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 t…
I Have Boolean line item for a module which consists of country and employee List as dimension. for another module having country as dimension and one boolean line item how can i check boolean line it…
Hi All, Hope everyone is doing safe during this pandemic. I'm trying to apply filters on time dimension on a standalone basis, but unable to do unless I bring in other dimension to columns. When I cha…
As a user, it would be nice to have the subsets indented under their parent lists when changing the applies to section in a module blueprint mode. This organization would mirror the same organization …
Hi kindly refer the following 3 screenshots: 1. A2 Account>Product# List 2. DAT02 PY Revenue to CY 3. Check Build Check Build is what I'm trying to get to but before doing so I need to figure the righ…
Hi. Good Afternoon. We currently have a rather large Model that serves various areas of the business. Currently all payroll related items are visible and we would like to lift and shift these modules/…
I'm seeing some unexpected behavior in a Lookup formula that is referencing a period formatted line item. When I manually select a value for Current Year, my lookup formula performs as I expect it to.…
Hi, for level 1, In 6.8.3 for module creation named SYS03 Country Details Module,I am unable to add the format List: G1 Region for the line item Region. Am I missing something? Please help.
