I have a module that has country and accounts as dimensions. My accounts are part of a composite list that roll up to segments. I've created a user filter using another module to show only the countri…
We currently have time functions to return the MONTHVALUE, QUARTERVALUE, YEARVALUE etc... it would be helpful to add a final function which will return the Time.All Periods value, this would enable de…
Hello everybody, I would like to insert a picture on a page. For that I created a text link Line Item. This link is connected to a picture on our MS Teams share folder. Even though I do have the acces…
Hi, Is there a way to put in one Formula for Actuals and another Formula for Forcasting? I was thinking I might have to create two Line Items (one for Forecast and one for Actuals) and put those formu…
When our team views multiple time periods over the year/years, they usually want to see a Trend view (all months in order (Jan-Dec) then Quarters then year to allow the team to evaluate activity over …
Hi, I need advice on how I would pull in past data into my Model. I have a Excel file that is attached and have set up the layout of the Model in Anaplan and have put the Formulas in my Line Items. I …
Hi, Looking for a solution to get the effective date for working on a location(Result(output Required)). Employee 1 1. Got hired on 15th March so output to be 15th March for the period March. 2. Moved…
Recently I came across and issue where Anaplan users won't be able to work if another user is importing a big file or running a process. it was reported by users that during those time Anaplan stops r…
Hi, everyone! Join me on December 9 for Anaplan Live! In my session, I'll be discussing the 5 foundational functions in Anaplan. These are the most common functions and understanding them will allow y…
We have got more than 500 models in our training workspace which is 130 GB. It is quite difficult to keep a track of all those huge models when it comes to workspace cleansing and even more difficult …
Hello, I am running into a strange issue with the rank formula. In the attached screenshot, you can see a line item with the formula: RANK(1, ASCENDING, SEQUENTIAL, CURRENT FLAG <> Previous Current Fl…
Hi, I'm working through the L1 MB exam and cannot figure out activity 5. The question asks you to update the formulas for the bonus and benefits lines, using a combination of data from the new role da…
Hi, I was under the assumption that the EXACT rounding method had fixed the issues with floating decimals? My use case requires several rounded export modules out of one calculation module and thought…
Hi all, This is an exercise to create a data hub and, as a preparation, I have asked to load data in a flat list in a preset structure as per below: Please note that there is Distribution Center? fiel…
HI In my module I have Profit Center list(25 items) and revenue Line item .I have also created 1 Boolean line item for approval process. so for each profit center I need to check approval boolean. Ins…
I need some assistance understanding the limitation of Version Formulae and how it interacts with Formula Scope. I have inherited a model build which has a comprehensive P&L module (down to GL level) …
Hi, I have two modules with project data. The first module has a dimension of serial numbers (1,2,3,4). it is not a numbered list. One of the line items is defined as a list format of project numbers.…
Hi, I have a Property module of Costs with following line items: * Amount (Number format) * Occurency (List-formatted with options One-off, Monthly, Quarterly, Yearly) * Cost Start (Month Period forma…
Hi, I have created an import process that takes any person from the New Joiner list that has a Start Date before CURRENTPERIODEND() over to the Employee list. This is all well, but then I would like t…
Could anyone help me with the questions below? 1. My Beginning Inventory is not showing correctly with the effect of ending inventory, it shows the same number, please see the attached screenshot. My …
Hello everyone, I am aggregating data in a module with three dimensions + Time: M2, which has M1 as a parent and corresponds to models R1, which is a list of roles E3, which is a list of employees and…
Hi, I have a module with various bank loans and maturities e.g. 2020-2028 - this is dimensioned by quarters. I want to create a module that sums up the total bank loans by maturity. I've used a formul…
Hi I have a module where teams input information on a quarterly basis. I then use this to pull through into a summary and compare against previous quarters etc. However, some teams only input on an an…
Hi Team, i request your help below query. I have three grid in my dashboard. second grid showing associate details(selected associate in first grid) with account name details he belongs in PA level. T…
Hi Experts, I have a doubt. I have created a module i.e. Module 1 and also created another module i.e. Module 2 with exactly same lists as Module 1. In Module 1, have entered so many data, but that da…
I have a list of accounts and a list of account managers, broken into three categories (IVAM, DIAM, CCAM). Sales managers must assign an account manager from each category to every account. I want to …
Hi, is there a good best practice to solve Text Conversion "1,234" to a number over Value(txt) giving finally NaN because "," will not be recognized by VALUE(txt). Numbers are given in text format by …
As a model builder, I would like to see greater flexibility to history export requests for Anaplan models. Context: The History Export function is critical for audit checks to understand if any partic…
The users' list should have a top-level for calculations. Currently, the users' list can't be used for inputting data as there is no top-level so errors occur when referenced by a line item without th…
