-
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…
-
Iferror formula
Hi, I'm trying to do a calculation similar to the IFERROR calculation in excel but I can only seem to do the IFTHEN formula in Anaplan. Does anyone have a suggestion for this? The excel function is IFERROR(X/Y, 0) Thanks, Tom
-
Question on LOOKUP Function
Hello - I have a seemingly simple ask and need help. I have a module one DAT01 with two dimensions ( Country and Year ) and a line item Annual Percent Increase and I have another module, DAT02 with three dimensions Country, Product Family and Months. I want to reference Annual Percent Increase from DAT01 into DAT02. I am…
-
Cell Calculation
Hi I am trying to quantify how our models are growing by building a calculator. I have just found the space calculator in the agile implementation app which looks excellent and will save me some time! However - I cannot reconcile the results of the calculator to the cell count listed against my existing model in Anaplan. I…
-
inquiry on how to execute time ranges to minimize model size
Hi Community, I have a question on how to minimize the model size of the client. Recently they ask to have an additional 2 Previous years on the model (which is done already). They added FY2017 and 2018. This reflects on all of their modules which greatly increased their model size. It is currently on 105GB already. But…
-
Level 3
SYS 03 is already built in module and it already has formulas. These formulas not pulling any data. Please advise.
-
Territory Effective Dating
I am looking for a solution to do territory effective dating in a model that can be used year over year without creating a new model each year. The ultimate goal is to roll up quota crediting to a specific Rep based on transaction date. Example: Rep A assigned to Territory 1 = 1/1/2022 to 5/31/2022 Rep A assigned to…
-
3.4.4 Activity: Create Stock Exceptions Review UX Page
Hi All, I am on Sprint 3 of MB level2. Could someone please let me know if there is any mistake in these numbers on Stock exceptions review page. I am not sure if they are correct or not as they all are showing in red values after apply conditional formatting. The source module is obviously INV02 and INV01 ( for SKU level…