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 ha…
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 …
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 extre…
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…
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 i…
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…
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.
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 …
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 dat…
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 show…
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…
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), …
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…
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 d…
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 IF…
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 th…
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!…
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 20…
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 spe…
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 a…
Hi, I am hoping someone can help explain / walk me through what this driver formula is doing. IF Driver Method <> 'SYS002 - Model Lookups'.'Flat to PY - 70% Owned Sales'THEN 0ELSE…
Hi team, As one of the requests from our client, we are trying to add "Sum over Selected Period" next to the sum "All Periods" The use case is, that we have a module with dimensions- 4 line items and …
Hi team, I'm looking at whether I can lock down a previous Version/s within Anaplan but continue to run multiple live versions, this would normally be where we have 1 standard live version but there m…
hi! I would like to be able to send emails to multiple people using the mailto function. To do this, I would like to create a function that allows me to set the company to which a user belongs in the …
Anaplanners, There is a requirement where I need to give the users an option to select the line items they want to view. For example, I have a module dimensioned by Projects and line items like Commen…
Module contains Investment Tranches maintained as a list as well as multiple investments as a separate list (Whole Dollar). A fixed $ Credit is input in a separate module, but then should be allocated…
