-
Numbered List - View
Hi Below are two numbered list screens. For Column 1, how does one toggle the view between system generated codes and Display Names?
-
IF function without ELSE condition
I am looking at a calculation where I want to have C = IF A > 0 THEN B ELSE DO NOTHING... DO NOTHING needs to retain previous value on C.
-
Dynamic module for list in a hierarchy
I need help creating a list for the market. I was able to do this at the retailer level, but how do you do the same thing for the market. I need to be able to do this so that I have the code for the market.
-
Resources every Anaplanner should be familiar with
Hi All, I recently thought about gathering the most important articles & resources that every Anaplanner should be familiar with. I was actually preparing it for myself, but decided to give it a go and share with everyone since it could be useful! Of course, all these materials are available at Anaplan Resources, but I…
-
Import between alternate hierarchies
Hi, I have the below hierarchies as follows Product Hierarchy: P1 Product P2 SKU Country Hierarchy: R1 Region R2 Country Alternate SKU Hierarchy: R1 Region R2 Country R3 SKU Both R3 SKU and P2 SKU are numbered lists. I have the below modules: Module 1 with dimensionality R3 SKU,Scenario and Time and a line item 'test'…
-
Level 1 Model Building
I'm not quite sure on how to change the summary for "headcount".
-
Level 1 Model Building
I'm currently taking the certification exam, and am wondering what to do when utterly stuck. I'm not looking for the correct answer just some assistance. My current question is how to to create a formula to pull data from another module. I've tried many different formulas including [LOOKUP:] but nothing seems to work.
-
Dashboard filtering selective access
Kindly suggest how to restrict the view access in the dashboard of unauthorised one.
-
Level 3 : Sprint 1 - TAR01 Detailed Sales Target (Names of Line Items)
Hi I have some doubts regarding the names of line items used in this module. Why this is important is because one can always judge from the name of the line item as to what should be calculated in the particular line item. Can I attach a screenshot of provided names and suggested names so as to get a better understanding…
-
Textlist on multiple dimensions
Hey Experts! Hope ya'll are doing well with everything happening around:) So there is this requirement where we require to bring in a list of selections into one single cell. My immediate thought was using a text list function (as i think that is the only way around it even though it has performance issues). Basically in…
-
Calculations based on text
Hi, I have an issue regarding how to set up a formula to get a calculation to work. I have a mapping module, where you can enter how a specific calculation should be done, looking like below: DriverComponent_1Calc_1Component_2Calc_2Component_3Revenues# units sold*average price per unitBLANKBLANK The format of the line…
-
Use Formula taking reference of a particular cell across any time period
Hi - Please help me how I can achieve the below expectation using a formula: * Say, I have 10 periods: 6 periods in past and 4 periods in future (i.e. the 7th period is the current period). * I calculate the mean of the first 6 periods (past periods) and store the same in the current period (say line item "Mean"). * Now, I…
-
Locking row item/s from deletion for select few roles on the basis of another boolean formatted line
Hi , I need help in the below query, I have a boolean formatted line item in source module published on a dashboard. As soon as the Boolean flag is marked “True” by ‘Role A or Role B’, the expectation is for corresponding row item/s to get locked from deletion for all roles except Role A & B on all the dashboards(two)…
-
Level 1 Model Building
Is this all correct?
-
Anaplan front-end language
Hi, I read that Anaplan language is browser-based but I changed my browser language to Spanish and I still see it in English... is there any additional step I missed? Thanks!
-
Dynamic Day Calculation
Hi, We're struggling with a conceptually easy topic which is surprisingly difficult to model build in Anaplan. For a dynamic ordering calendar, so the days when you can order can be adjusted and are not fixed, we're looking to define the amount of days in between two ordering days. Technically I'm stuck at the point where…
-
Level 1 Model Building
I'm not quite sure how to get rid of the column heading that aren't necessary.
-
Module Pivoting
The Module currently does not have Version in it's Pages, Column or Row and Version is now required in Pages. Been trying various options.....still can't find it. Where else have I been missing?
-
line item with no time dimension
Hi, I have a module with no time dimension.In this module I have a line item "Contract Amount". In another module that has time dimension, I also have a line item "Contract Amount". In Jan 2020, value of the contract amount is 100,000. In Feb 2020, value is 120,000.In Mar 2020, value is 130,000. It is now June 2020. The…
-
How to set default value for list item
Hi,everyone. Can I set a default value for a list? I have a list of calendars. For example, if the current date is February 1, 2020, I would like to display February 2020 in advance. Best regards. Taku.
-
Level 1 Model Building
I completed the last two steps but the first two I just can't seem to get right.
-
Selective access based on property
Hi all, I have a list of customers belonging to a region . Every customer is linked to a unique account manager. I have a SYS- Customers module, with the customer list as a dimension and the account manager as a list-formatted line item and the region as a list-formatted line item. The lists of account managers and regions…
-
Character limit of 60 on Anaplan code - Possible solution to address the issue required
Hi, My Anaplan model contains an SKU hierarchy roles up to the top with 9 different levels... The codes for each of these levels are concatinated from the top level LevelsLevel CodesLevel 1 - Organisation Concatination of first and last 3 digits of Level 1 nameLevel 2Level 1 + Concatination of first and last 3 digits of…
-
Picklists and Selective Access: Using a List Formatted Line Item
Are there limitations when applying selective access to a picklist with "double" selective access enabled per the link below? https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Dropdowns/Picklists_and_Selective_Access.htm In List: Employees I added a Property named "Filter User Access" to filter access to…
-
Level 1 Model Building - Design
Hi In the Level 1 Model for Unicorn, Size was defined as a List and the Products file imported shows a 1-to-1 relationship for Product -> Size. Product CodeProduct NameFamily CodeSizeP001Nutzo BarCH100gP002Raising the BarCH200gP015AnapoppersSO500gP016Juicy Lucy gummiesSO100g Assuming, the Product -> Size is a 1-to-many…
-
{Trick] Previous on regular list / sequential calcs using time as days
Hi everyone, I've been talking about this in the forums a few times and recently @gaurav_sharma-bng told me he couldn't get it to work so here's a quick topic on how to do this. Used for: Doing sequential calculations in Anaplan or doing previous on a regular list Disclaimer: as we're using time as days, it's quite a heavy…
-
Anaplan equivalent of the "Product" Function
I would like to use a formula that calculates the product of a series of items.
-
SUM in conjunction with boolean filter
I have 2 modules: Data Module and Dashboard module. 1. Data Module has: Region (List Item) Product (Line Item with List Items called PRODS) Value (Line Item) Export? (Line Item - Boolean) e.g North America PRODS=Mountain Bike 100 True Europe PRODS=Mountain Bike 50 False I would like the Dashboard module to have:- Region…
-
Lead formula not allowed for formula summary
Hi, I have a line item in percentage (POC). I already created the formula and set the summary totals to formula to get the correct %. But I need the value of the percentage for the following year. for example my period is Jan 2020, I need to reflect the value of the percentage in Jan 2021 in my Jan 2020 period. I tried…
-
Calculate Week and Days in a Week: Not a straight forward logic
Hi All, Hope you are doing great! I have to create a peculiar way to calculate weeks and then calculate the days in each of these weeks. Please find below the rules to create a week- * Weeks will be defined from Sunday to Saturday. The only exception to this rule is stated in rule(4) * The usual number of days in a week…