For large usage of Anaplan (multiple data hubs and models), it is important to monitor the flows between models. Anaplan is the ideal tool for that but currently many of the necessary info is not read…
Lets say I have a line item LineA with an Applies To of Users, and a line item LineB with an Applies To of Organization. Anaplan lets me make the formula of LineA, "LineB". I understand the principal …
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…
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
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…
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'…
The Data should like Pic-1 but after import I am getting as Pic-2. Though I followed all imports correctly, still data didn't show up. I have shows Imports for reference. Thanks Friends.
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 wit…
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 t…
I read a good article on LinkedIn by our colleague Mark Warren. It was about Pre-Allocation for avoiding model saves. Model saves may have impact on performance. Please see the LinkedIn post: https://…
I'm Trying a statistic forecast. And there is below statement in this site (https://community.anaplan.com/t5/Best-Practices/Statistical-Forecasting/ta-p/40359). * Multi-Level Forecast: Ability to fore…
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?' …
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" …
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 possi…
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 bigges…
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 su…
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 …
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…
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…
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
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 2…
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…
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. Than…
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: 'SYS0…
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+WR…
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…
