-
Add number of business days to a date
Hi, I'm trying to find a date that is day 5 or 7 or 16 business days later than Start Date, based on a cell that contains Num Biz Days. I've created a Calendar module where I exclude weekends and holidays I've marked such that I have a Cumulative Working Days where I can Lookup Start date (say it returns 341th working…
-
Time Filter on Page Selector
I need to filter the data in modules for Test Version(1) in current year. For that I have created one filter(version and time specific filter) line item in to filter the data for current year and Test Version(1). This filter is working fine in the modules where time is in columns but I'm not able to apply this filter where…
-
No Settings Tab
I can only see the contents of my models and there is no settings tab. What happened?
-
refactor the action info tab/API to allow for flows monitoring
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 readily available. The first and foremost thing to do is to set the API so that the imports endpoind of a model actually gives…
-
How to create a filter
Hi @ChrisAHeathcote Appreciate if you advise on how do I create a filter for a column name I'm trying to create a filter by "account type" . Thanks.
-
Why is a line item referencing another where both have no overlapping applies to ok?
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 of using SUM/LOOKUP/SELECT etc. to find the values in each dimension to use where the dimensions are missing from the line…
-
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…
-
Import values is not showing
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.
-
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…
-
Manage Pre-Allocation in List/Config
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://www.linkedin.com/posts/mark-warren-45649ab_reducing-saves-in-data-hubs-activity-6796397489789399040-uGOR The led me to the…
-
The Level of Statistical Product Forecast
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 forecast at different levels of the product hierarchy (i.e. Top Item | Customers, Item and Brand level can all have stat…
-
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…