-
Is is possible to apply lookup in the same module to pick value of the previous line item?
Hi, Is it possible to get the value of the previous line item with in the same module? if yes, what should be the formula? Thanks!
-
Planual Explained - Day 6
"Rule 1.05-10": Article 1, Chapter 5, and Rule 10 – “Never delete list and reload the list as daily occurrence”. Using a unique key to update to values rather than delete and re-load. It goes against P & N elements of PLANS if you wish to do so. Here is how it was done in Pre Planual Era: When we had to delete the…
-
Numbered List Actions - New UX
Hi All, We now have the ability to create "Forms" in the NUX which replicate the old Create action but with additional functionality, such as naming the item on creation. Is it yet possible to replicate any of the other numbered list actions such as copy branch and assign? Is it also planned to enable forms to be created…
-
ITEM formula for on flat list
Hi, I have two modules (see pictures). The Attainment Employee Position Check module checks which positions an employee has during the current planning year and the Attainment Employee Active Position Check module will use the information used in the previous module. So in the example below an employee named TBH has the…
-
Alerts in Anaplan Mobile App
Hi Can we get alerts in Anaplan Mobile App For Example: If Quantity requested is out of stock then an Alert should be given by the Anaplan Mobile App. Do we have any function like this in Mobile App Please suggest if exists Thanks Sri Nitya
-
Module to module import issue
Hi We have configured some imports within our modules where 1 line item is imported to another line item from one list member to the next. The List we have used here is Target Setting Stage. So a target being set in one stage is copied to the next stage using these imports as a Previous Stage Target. Now, the issue we are…
-
Dynamic Charts in ALM
I keep having issues where I create a dynamic chart using a time filter (eg. Rolling 13 month filter) however when publishing it to live models it stays static which causes some unnecessary maintenance each month. Can this be fixed??
-
Forms - choosing parent options greyed out
I have created a form in our DEV environment and set up a form to add items to a list and has a fixed parent item. When I imported the model to our TEST environment and repointed the NUX dashboard to the new model, the form parent (either manually selecting or fixed parent) is greyed out and I can't work out why. I have…
-
Delete line items based on time period
Hi, I want to delete selected line items in a module based on their year time period. i.e.: i want to delete all records that have a year time period format of FY19. Is there a way to do this? Best, Amanda
-
How to calculate % share?
Hi, I have a Module with List of Persons who made contributions as a row dimension along with their respective Contribution in a separate Line Item, now I want to calculate how much percentage share of each person in my second line item. Kindly assist. Thanks!
-
Chart with filters
When I click the icon, there's no pop-up showing up. Any reason? Thanks.
-
Export button on the Imports tab under Settings > Actions
I frequently export the Imports table under Settings > Actions when troubleshooting or working through a model. Connections between models or modules/lists through actions are not displayed in the model map so I highlight the Imports table and copy/paste into excel to diagnose/troubleshoot actions and discover…
-
Planual Explained - Day 4
Note from @JaredDolich : I'm proud to be collaborating with @Misbah to add some detail to the Planual. You can refer to @Misbah's original post here. The Planual is located here. "Rule 1.05-02": Article 1, Chapter 5, and Rule 2 “Always use a code.” Using codes is more efficient for loading and using lists so strive to…
-
Time dimension not syncing from module to module
Hello everyone, I have noticed when working on some models that the Time dimension doesn't sync from module to module - as in the attached picture. Both modules have the same Time Range - Default Model Calendar - and the same Time Scale -Month. Is there a reason why this is happening and how can I fix it? 2 modules in the…
-
DCA Import Access For Combination List
Hi All, I am working on a model where I have a module with dimension including a combination list, version lists & stages created with respect to P&L. The combination list has been created with the combination of states (rate area), product (Sku) etc. Now to restrict the access of each Regional Finance Manager so as to…
-
How to calculate forecast percent based on latest 3 months (average) actuals?
Hi, I have a source module without a version list/dimension. It contains only actuals. What I would like to do is a new module that contains actuals and forecasts. There should be a version list, which contains Actuals and Forecasts. Forecast figures should be calculated from the latest 3 months average (from actual…
-
Custom Time Range - Switchover
Hi Team, The Time Range training states that 'If you want to use the switchover date, you'll want to use the model calender' (see below) I ran some tests and Switchover was working fine when using a Time Range although you cannot select a Switchover Period per Time Range, it is as per the Model Calender Does anyone know…
-
Ranking with continued sequence
Hi Community I have a simple list containing values, but some of them have the same values. So when I rank them, the ranking is quite discontinued. For example, 1,1,3,3,3,6,6,6,6,6,6,6..... but what I want is 1,1,2,2,2,3,3,3,3,3,3,3,....... How to approach it. Thank you. Best, Qianru
-
Start Month of a Financial Year
Hi Experts, Let me ask how to fetch start month of a financial year. What I want to do is to filter client's invoice data, that invoice period start from the start month of previous financial year. e.g.) If the current month is Apr 20, the invoice data should be filtered from Apr 19 to Apr 20. If the current month is Mar…
-
How to get Min/Max and Today's date in Anaplan
Hi, We are trying to get the Min/Max and Today's date for data in the Anaplan Module. Below is the sample data present in the module. DateCustomer countRevenueSaturday, 2 May 20201001000Sunday, 3 May 20202002000Monday, 4 May 20203003000Tuesday, 5 May 20204004000 We expect to get 2nd May as Minimum Date, 5th May as Maximum…
-
Ability to create modules and dashboards automatically based on selected dimensions.
Automate the creation of modules and dashboards based on dimension selections from a start model building dashboard according to the attached screenshot. Category: Model Building Automation.
-
How I can made logic against time dimension?
Hi, I would like to understand how I can make a logic against Anaplan Time dimension list. Target: To make function for "Test" line item which tap True (to Test line item) for all periods where "Actual" current period is equal or smaller. Cheers, A
-
Planual Explained - Day 3
"Rule 1.06-02": Article 1, Chapter 6, and Rule 2 “Don't use subsets on large lists.” It is better to create a list on its own if the Subset is more than 75% of the list. This goes against “Performance” of PLANS if you wish to create subsets on large lists Here is how it was done in Pre Planual Era: Without checking the…
-
Planual Explained - Day 1
Rule 1.01-01: Article 1, Chapter 1 and Rule 1 - Never use SELECT with TIME. This goes against “Sustainable” of PLANS if you wish to use SELECT with TIME. Use Case: Let’s say we have a source module where we have a time dimension and we want to bring in the Annual Revenue for one year into our target module (Ignoring rest…
-
How to calculate forecast percent based on latest 3 months (average) actuals?
Hi, Current setup: I have a source module where I will get actuals percents every month. The module doesn't include the version dimension/list. Target module: I want a module that includes version actual, forecast, and probably later other versions as well. I would like to get from the source module the actual (allocation…
-
Concatenate users into a text field
Hello, I created a matrix, including two lists (tasks list and the built in users list) as dimensions and a boolean formatted line item in order to set write access for an other line item through the Write Access Driver. That part works, no issue with it. But I want to list (concatenate) in a simple text formatted line…
-
Line Item Text alignment
Hi All I have a questions when i enter the line item TEXT ,is it possible to change Align Right / Left or Center and shift to another row in single line item e.g. Text (A)
-
Assign the module name for the line item
Hi Community I have a module with the following structure: Module Name ---INPUT--- Transportation fee INPUT Meal fee INPUT --- CALCULATION --- Trip expenses CALCULATION What I want to create a column named 'Module Name' is to display the module name; In this case, it is input and calculation (input and calculation are…
-
Mailto fuction-File attachment
Hi, Attachment of a file is possible while using mailto function ? If anyone knows ,kindly guide us. Thanks Neeraja
-
Summary settings: total sum
Hi All, It would be interesting to have an option "Total Sum", that only aggregates the value for the ultimate parent in the hierarchy. This would almost completely remove the need to create flat lists with a lot of benefits: - less complexity; - no mappings between lists; - easier/more intuitive to model While retaining…