-
L1MB 6.11.1
Can anyone help me with this? I added 3 line items but only 2 columns are showing up. I checked my work and I am missing the budget column
-
L1 Lesson 6.9.3
Hello, Is there a way to delete the All Products column? I can't delete it from the Products list because it is considered a top level item somehow. I'm not sure how it got there.
-
Boolean, lookup and lists
I am stuck - I have a Boolean that I want to populate based off the value in a given list. If this was excel I would write the formula as If Pay type = H then True else false. But I know that I can't do that. So I moved on to thinking I need to use the lookup function, but I am at a loss on the syntax to ensure it is a…
-
Level 1 Lesson 6.6.3
Hello, I am not understanding why I don't have a date showing in the current period start row and why I don't have a check in the actual period row as well but in the forecast period and forecast months only instead. Any help is appreciated.
-
Importing into a Numbered List from a saved view
Hi All - I feel like I am missing something simple here. I have a saved view from my data hub model that I am using to import into a spoke model. I am setting up a numbered listed in the spoke model b/c of duplicate data. I have set up a display name and have successfully imported the data from the saved view. What I do…
-
1.3.4.3 UPDATE SYS07 LOCATION DETAILS MODULE
HI ALL, I'm stuck in this activity, i download the file location but i have issues like you can see in the screen shoot can you help me please ?
-
Level 1 Lesson 4.6.8
Hello, Any advice on how I can get the codes to show in the code column? I'm not getting any errors when importing the data.
-
3.6.1.1 Create Product Supply Manager Role - Where do I start?
Hi, community, I am working on this one now. So looking at this: * Each Product Supply Manager should be able to update their assigned products and product SKUs, but only view their assigned Product Family across all regions. This is how I saw it: * I need to create ACCESS module where I map user against SKU. * I can use…
-
Driver Calc help with logic
I have a driver called "set to plan" which is just assigning the planned amounts to the forecast periods, but this is only happening for 2022 forecast periods. The previous driver Calc: IF Driver Method <> 'SYS002 - Model Lookups'.Set to PlanTHEN 0ELSE 'REP001 - Balance Sheet (Reporting Output)'.Amount[LOOKUP: 'SYS006 -…
-
3.5.4.2 Create Distribution Center Capacity Module
Hi, I am having trouble getting the Total Beginning Inventory to map correctly. I am using the formula: 'INV01 Inventory Ordering'.Beginning Inventory [SUM: 'SYS08 SKU Details'.Supplied By]. I get the following error: "Datatype mapping used for aggregation doesn't match any dimension of the result" I'm not sure how to map…
-
Selective access in dropdown list
Hi, How can i apply the selective access write only in my dropdown list ? I have a list with selective access both write and read and in my dropdown list i only want to allow users to select those members that they have write access. Thanks in advance for helping. Regards, Tom
-
Boolean Format Option - Radio Button
Hello, When building a model & NUX page, I would like the ability to set the format on a Boolean such that it can be visually displayed as a radio/toggle button (example below). This would help end users more easily understand certain inputs when setting parameters. Boolean Format Option: Thank you, Jeffrey
-
UX Idea: Toggle Allow editing at Worksheets
Hi all, I found lack of functionality in worksheets related to editing. You cannot apply read only mode to input module on Worksheet like you do on Boards. Currently all worksheet pages are editable and can be controlled only using classic UX role-module access. To keep UX consistent I propose to add Allow Editing feature…
-
Rename a list item through a NUX page
Hi Everyone, Is there a way to rename a list item through a NUX page? Thanks! - Shubham
-
Sum over a specific periode
I need to sum values inputed in months into a line item independent from time over a specific time period already determined by start and end date how can i do that please ???
-
User based calculations
Hello - I have a question which ultimately is related to using the users list in module design. Was hoping someone could confirm my theory, or even better, provide a more efficient way to set this up. Here are the details on what I'm dealing with: We have a module setup for budget vs. actual analysis, in which the module…
-
Coupa -> Anaplan
Has anyone seen any documentation, white papers, materials on integration with Coupa? Maybe more so from a functional, use case perspective?
-
Selective access functionality not working in module
Hi everyone, The Dynamic cell access (DCA) functionality of Anaplan which can be utilised by checking the Selective Access box while choosing the format of the line item is not working as per expectations. The dimension of the module is a combination list and we have the Rate area coming up in a line item on which I've…
-
3.4.3 Activity: Create Country Summary Module
Hi In Level 2.3 section 3.4.3 the question hint says... "For this formula, you will need to add a list-formatted line item named Country Made In in the SKU Details system module. " "SKU Details" are held in SYS08 - however there is no line item named "Country Made" as shown on the screen shot below. I've looked around and…
-
Top 10 Helpful Tips From Anaplan Learners
With so many new Anaplan learners joining the Community, everyone is at a different place on their journey—some just starting, others in the middle, and still others already finished and offering support or assistance to their peers. Recently, we invited members of the Learner's Lounge Group to share something they've…
-
Seven advantages to building and modeling in Anaplan
The benefits of Anaplan cannot be overstated. Today, I’m excited to share with the Community my experiences and the benefits of building and modeling in Anaplan! I enjoy using Anaplan because it allows me to avoid complicated technical scripting and maintain related infrastructure, saving a tremendous amount of time. This…
-
Text Based Line Item Subset/Page Selector Filter
So I have project list. A module which captures weekly update of the project, its not dimensioned by time. I record the previous weeks updates using an action, avoiding time completely. Currently i have 10 line items in my module which captures previous week's updates. Is there a way i can give a view to the end user where…
-
Previous Year to Date Calculation
Hi everyone, I am in need of a formula for specific line items from our P&L that calculates the previous year's YTD values. For example our YTD currently shows Jan 22 - May 22. Ideally I could have a separate model to choose each line item and show the YTD for Jan 21 - May 21. Is this possible?
-
DYK - WEEK 5
Did You Know? That “Brought-Forward” feature in Anaplan model helps you retain the last period of the previous year even if the model calendar is rolled over to next fiscal year. This feature is extremely powerful in Financial Planning & Analysis especially in Balance Sheet Account Planning where the ending balance of…
-
DYK WEEK - 8
Did You Know? That You can make cells editable in the formula driven line item but that’s only if you are using Anaplan Native Versions. By default, it applies to ALL VERSIONS but you can change it to any one of these three options i.e., “All Versions except Actual”, “Actual Version” & “Current Version” Video here…
-
4 Quarter Average for a year
How to get 4 quarter average of the same year for all quarters in a separate line item(Quarter formatted) Thanks.
-
Percentage format, eMail body, TEXT Function
Anaplanners, Running into a rather simple issue, wanted to use the anaplan mail to function with the body picking up few data from the module, for example: - Marks obtained by each student is stored in line item called 'STUD1.1 Student Details'.Marks Marks Obtained = 70% Now my mail body formula would be "Marks Obtained =…
-
Error: Dimension of mapping used for lookup doesn't match any dimension of the result
Hi gurus, When building the reporting module 'REP04'(the target) I've tried to reference an existing module 'EMP03' (the source) for the calculated medical costs. REP04 has two dimensions 'Region' and 'Role' whilst EMP03 has 'Department' and 'Role', hence I tried the mapping module 'SYS08' to fill the gap. Thought it's ok…
-
Add a dependent to the listings with Top Level.
hi! I want to add a dependent to the listings with Top Level. I would like to prevent TopLevel from being selected in the pull-down. How to do it？ Please help me.
-
Lookup function help
Hi.... I need some support in creating a formula to for a look up I have created a mapping module where: 00.nondefault is a list Stage 1/2/3 is a list Y/N is a list Line item is boolean I need to map it to another module so that in the Anaplan classification it identify whether it is stage 1/2/3- not sold etc. I have…