Modeling

INV01 SPRINT 3 ISSUE
HI Team, I have few issues with the formula, its right or wrong? i have noticed 3 issues in my model 1. For Beginning inventory my formula is IF NOT 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory here in week 2 of beginning inventory,…
Issues in module 6.8.4
I have set the hierarchy of G2 country but the error shows hierarchy not recognised.
Use Non-numeric Value to Drive Conditional Formatting
Ability to use a non-numeric value to drive conditional formatting. Ex. I have a text formatted line item where my values are Red or Green. For my values to set the condition, I can have text = "red" or text = "green" rather than having to create an additional line item that that resolves to a numeric value for my…
Reducing Saves in Data Hubs
Data Hubs typically include large lists or numerous lists; both contribute to longer save durations. Model saves block other model actions, so we want to reduce the frequency of saves as much as possible. Reduce the Frequency of Saves First, put the data hub model into Deployed Mode. Learn more here: Enabling and Disabling…
Memory usage from text concatenation
We know that 2.02-04 Text Strings are bad for Anaplan models and that text functions and formulas using text are the slowest (slow in comparison to similarly-sized numeric formulas). One of the biggest contributing factors to the poor performance of text is the impact on the memory used by Anaplan. The following diagrams…
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…
INVO1 SHIPPING METHOD FORMULA
HI I got stuck in the shipping methods where am trying to using all sort of formula but shipping methods showing different error my formula: 'SYS07 Distribution Center Details'.Default Shipping[LOOKUP: 'SYS08 SKU Details'.Code, lookup: 'SYS08 SKU Details'.Supplied By] error : Data type mismatch: format other than LIST or…
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.…
P3 SKU no items
Hi team, am attempting level 2 sprint 2 exam and suddenly when i opened my module its showing an error and asking for work space admin access . any one please help me
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?
New Modeling Experience: Undock tabs to be presented as another window
In the newest release new modelling experience UI was added, but it lost one feature I find very convenient having in Classic UI. When you perform Drag-n-drop on a certain tab in Classic you could see a floating window with the chosen module/dashboard in it. Please add this feature in New UI as well. Thanks, Kirill
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…
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…

Modeling

Discussion List