-
Avoid circular reference using list member logic
Hi all, I’m new to Anaplan and would really appreciate help with the following: I'm trying use the same module ('Module A') for two stages of a calculation (before and after); for this, 'Module A' has only one dimension; a list or two members ('Before' and 'After'), image attached. it's first line item (Item A1) sets a…
-
Want to be able to display a property of a list as a dimension
Hi Anaplanners! I want to be able to display a property as a columns on a Dashboard. Let me know the best way to do it. Thanks in advance! Regards, Garima
-
Is it possible to hide row Dimension list in Dashboard
Hi, I have a module with two list(one list as page & second one as row) with multiple items. When i am displaying this module into dashboard i want to hide row list. Is it possible to do that?. Thanks! Suman.
-
how to add text/remarks
Hi, I would like to add remarks/text as shown in the pic below. I've tried to do it via formula but it doesn't roll up to the highest hierarchy level. For example, if i choose "Asia" , the text doesn't show. But if you choose a lower hierarchy level, it's able to show the intended text. Furthermore, the text alignment is…
-
Level 1 Module Building Exam - Model Building Activity 5
Help, I get all zeros for my results after building the formula in EMP02 Employee Expenses. When I set the Role to list, The text disappeared in my SYS08 Employee Details. I am two hours into this without a solution. Here are some screen shots: SYS08 missing data in Role column Role line item as a list "Role" Formula…
-
Moving numbers from one column to the next
Hi please refer screenshot below. I am trying to move the last number in the column highlighted in red (Redistribution Ratio) to the next column, Finalized Redistribution Ratio. There are 20 rows in the highlighted part of the column. Redistribution ratios will automatically recalculate for each country, formula already…
-
Issues in module 6.8.4
I have set the hierarchy of G2 country but the error shows hierarchy not recognised.
-
Module Importing through Connect to anaplan model
Dear Team, I am Pursuing My Level 3 certification, I am not seeking help on Modelling But needed a small hint on the import view. I think I am missing something, I try to find the RCA but unable to solve it. Problem Statement- My import view of the G4T List is not coming as expected. Here for each Territory all account are…
-
Conditional Formatting for Summary
Hello, I'm wondering if there is a way or workaround to apply conditional formatting to a summary for a line item WITHOUT applying that same conditional formatting to the children that sum into the summary. To reiterate, I'm looking for conditional formatting for the week ending value shown below without applying it to the…
-
Use of CUMULATE function
Hi I'm trying to solve for the following: The screenshot below shows the two columns am trying to accumulate, Rows are the A1 Accounts dimension. The next screenshot shows I have a column for Country and is list formatted with G2 Country. Now, if I am trying to sum for each country (e.g. US, Canada, UK etc.) couldn't I use…
-
Question on RANKCUMULATE formula
Dear all, Kindly refer screenshot below. I am experimenting with the RANKCUMULATE formula with two versions shown below, respectively in the columns labelled "Account Counter 1" and "Account Counter 2". "Account Counter 1" which has the formula RANKCUMULATE(To Change, 1, ASCENDING, TRUE, Country) is working correctly.…
-
How to take Average of Prior Year Values
Hi Anaplan Community, I am currently using the formula below to take a moving average of my prior year value. So for instance if this formula is in my April 21 month, it is summing April 20 to April 21 and taking the average of that. I want to adjust the formula to look at just the full Prior Year Jan 20 to Dec 20 and…
-
List Formula
Hi - I'm trying to pull the value of module cell into a list. Please could you advise why I'm getting an error?
-
Problem on Importing 'SYS08 Employee Details.txt' file
Hi, I got some problems when importing SYS08 Employee Details.txt file while taking level 1 certification exam. I attched my screenshot. I would be appreciate if anyone can offer any suggestions. Thank you in advance.
-
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…
-
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?
-
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?
-
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…
-
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…
-
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…