Modeling

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…
Time Format in Jan,2021 Feb,2021,Mar,2021
How can i change this date format, can anyone please guide date format
Calculation of Payment Frequecy
Hi All, I've one use case where I've to calculated payment according to payment frequency i.e monthly, annually and quarterly. I've system module dimensioned by lease where user enters lease start date, end date and payment frequency. For e.g. Sr. No Start date End Date Payment frequency Lease1 4th-May-2012 12th-july-2022…
EMP03 Employee Drivers by Role does not return any data
Hi Not able to retrieve data for Bonus, Medical costs etc.. though all the formulas are correct. Screen shot attached
Getting zeros when using the LOOKUP function
Hi! I am getting zeros in my data when I am using the LOOKUP function. What are the possible reasons for this? I am sure that I am using the function correct. The function works but the data only shows zeros.
Lookup based on a boolean line item
Hi, I have a target module INP01 with 5 dimensions (P1, C5, Size&BPC, Time, and Deal Levels) and I need to bring values from another module DAT05 which has 4 dimensions (P1, C3, Size&BPC and Time) The point is that it needs to be done based on a boolean line item selected month? in DAT05 (which is true for the month…
Identifying list members with booleans
Hi, I need to identify list members using a boolean. (What I tried is at the bottom) In a system module SYS06, I have a line item "P2 Product Brand" that is populated using a list (shown in photo 1), it is list formatted. Photo 1 then, I created a boolean line item that is intended to check in another module SYS03 (Photo…
How to sum time ranges
I have a problem when aggregating lineitem by time . I want to aggregate Amount by "Aggregate Lineitem" (From Jan-21 To Mar-21). The Module A&B has set by time range, so we can't do it. Table A ( Time Range : past 2years) ListMonthJan-21Feb-21Mar-21Apr-21May-21LineitemAmount A100200300400500 Aggregate✔✔✔ Amount…
Level 2 Model Building: Conclusion DATA02 SKU Volumes Data Issue
Good Day! The instructions for importing DATA02 SKU Volumes module says: "The results should have none ignored and 0 errors" Well, I had a large number of ignored records, and I did not have summary data included. After some digging, I discovered the problem. The data I imported into DEM04 Demand Module, first, Misspelled…

Modeling

Discussion List