Modeling

creating Sys Account SKU Filter
what formula should I use to check if the total of all product SKU volumes over all time periods the value is not equal to zero?
Allow filters across multiple line item formats
I need to be able to apply a filter to my line items to show any line that is blank regardless of format. Currently if I use >0 it will hide all lines with text formatting. The ability to add 2 filters for is not blank or is >0 would also be an acceptable solution
Formula to find the age
Hello, Can you please help me with an info? Is there any formula that can be used to calculate the age if we have the date of birth? Thanks
Anaplan "Concat" & "Nested IF" Best practices
Hi Anaplaners, I have a module with 5 Line Items, all formatted as text. I have to concatenate the first 4 and give the output in 5th. However , out of the first 4 only the ones which have a specific value will be concatenated. (Eg. if 1st is "ABC" only then it will be a part of concatenation else not.) So there can be 16…
Error : Evaluating the forecast in Hold Periods ～ Statistic forecast
I'm trying to evaluate the statistical forecast by using Apply Hold Periods. But when I set them, the almost of product's best-fit forecast is set to New Item Forecast. How can I correctly evaluate the forecast?
How to use batch file process ~ statistic forecast
In statistic model, there are some instructions and power point file. -Daily Batch Process for Demand Forecasting In this document, I can see there are some Batch Process or import actions. But there is no Actions in the Statistic forecast model. How can I run the Batch Process?
Average 3 months data
Hi, For your assistance please. I want to get the average of the past 3 months, however, the average result should be post to the remaining months. In the screenshot below, I created three lines items: Commission % - input data Latest 3 Months Average (Comm%) - I used this formula MOVINGSUM(Commission %, -2, 0, AVERAGE)…
New UX: Type Directly in Text Field Card
When modeling in the New UX, I've saved a few card templates for the various types of text I plan to use in my designs. Saving a template card means I've gone to the trouble to do all the work upfront, presetting all the formatting the way I want it to be. However I still have to enter the card's edit mode just to actually…
Unable to edit the cell
Hi, I'm trying to make the last cell "SDR Action Plan" editable but it doesn't allow me to do it. Please let me know what mistake I've made. Thanks.
Referencing models in another workspace in real time
Can a calculation referencing a line item from a model in a different workspace be accomplished in real-time? Or will it require other forms of interfacing?
New Color Palette
We have been using the same old color palette with very few options of color in the classic UX or modules. Similar to the CF provided in NUX, can we also get the same option in the modules which will help us if we are using saved views in the pages as we can't NUX CF in that situation?
Period() Function -- Driven by Model Calendar Settings?
Hi All, Was doing some review reading and saw the note on the Period() function, for which I've always been a bit "hazy". ...From the instructions, it looks like the key thing is that results of this one are driven by/determined by the settings in the Model Calendar ("Time Bounds"?): * Result must fall within the Time…
Level 2 Sprint 3 Product Replenishment UX
@JaredDolich I have created my Product Replenishment UX and I'm at the point where I am verifying the end user checklist. I cannot edit the submit PO request or override suggested order amount. I have added DCA to INV01 for write access but it's still not allowing me to edit the cells. Also, my chart at the bottom of the…
Apply filter on time when it is in page selector
Hi I have 3 Versions, and time as a dimension 5 years in modules. For Test Version1 I should see FY 19 and FY 20 past and current year. For Test Version2 & Test Version3 I should be able to see all time periods. For that I have created one filter(version and time specific filter) line item to filter the time based on the…
How to calculate Month to month Growth Rate?
Hi all! What is the way to calculate Month to Month Growth rate (from the beginning of the time scale) if I have Sales Volume by month at monthly timescale? I have: (Volume by Month - PREVIOUS (Volume by Month)) /PREVIOUS (Volume by Month)* 100% I wrote the formula but it doesn't match the math result (when I'm making…
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…

Modeling

Discussion List