-
Add Few More Features on Manage Models Screen
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 to access someone's own model or accessing any model and making that as a favorite. Hence proposing an idea to 1. Have one…
-
Rank Formula Issue - Not Starting at 1
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 Flag, Current Flag Mismatch) I have displayed all related line items. A screenshot of the filter on the view has been provided…
-
Level 1 MB Exam- Activity 5
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 data and module SYS08. When I update with this formula: IF Employed? THEN Salary * 'EMP03 Employee Drivers by Role'.Bonus %…
-
Still ROUND issues with EXACT?
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 it's good practise to use ROUND() only once in the calculation module and not in every export module. Yet, I just…
-
To pull or not to pull?: Loading Distribution List to SYS07 Location Details Module (Lvl 2 1.3.4.3)
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? field to it, which was already set when I uploaded this assigned model. Since it is there, I have uploaded the true/false…
-
Approval process
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. Instead of that can I check only one boolean so that all the profit centers should automatically checked. Is there any…
-
Version Formulae & Formula Scope
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) split into its respective areas - revenue lines, cost lines, etc. Each respective area naturally points to a different part…
-
Getting data from one module to another
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. this list is a numbered list. The second module has a Dimension of the project numbers (numbered list). I need to pull data…
-
Create Forecast based on date and occurence in Property Module
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 format) * Number of Months (Number format) I want to feed this information into a Calculation model that has Time as a dimension.…
-
Move employee from New Joiner list to Employee list
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 to delete this very same person from the New Joiner list. How can I manage that? Best regards, Johan
-
Level 2- Sprint 3- INV01 Question
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 formula is IF NOT 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning…
-
Bottom-up Summary based on unique list members
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 has E2 Team and E1 Group as parents. I am mapping my list of employees to their Roles which is why I have E3 as a dimension…
-
Date input query
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 formula YEAR to extract the maturity year, but I can't seem to be able to sum on this year? Can anyone assist? Thanks!
-
Formula - last input
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 annual or half-yearly basis. In my summary, is there a way to pull through the last time teams input? Thanks in advance,
-
Count of records
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. Third grid showing account name details of same person in BU level. 1) I need to display one more column showing total counts…
-
Data in 2 modules with exactly same lists
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 data is not appearing in Module 2, which is same as Module 1. Is it the expected behavior? where we have 2 exactly same…
-
Sum from list item property
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 aggregate the account metrics for all the accounts managers in a single table. The first image below shows the account…
-
Easy Question (Moving the Row Bar in Anaplan
Hi, I would like to know a easy way to move the Row Bar in Anaplan so I can see all the words in my Line Items? Pic is attached. Thank you
-
Conversion Number as Text like "1,234" to Number over VALUE Function -> VALUE(txt) w/o NaN
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 client as "1,234". Or is it easier to re-format the numbers in the uploadfile...by the client? Thanks in advance for a short…
-
Add flexibility to history export requests for Anaplan models
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 particular user activity/imports/processes might have caused a data issue or some connection to break. It is important as part of…
-
User List Top Level
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 the user dimension.
-
Select a specific version when creating lookup formulas
Hi, It would be great if we could have formulas where we can specify a version (like it works for actuals) or if we could apply any line item to a specific version.
-
Make Versions a Format (DataType)
Make Versions a list format so we can use with LOOKUP logic based on user selections. Would prevent the need for versions mapped to a pseudo-verison list with IF/THEN logic, ultimately reducing complexity and increasing ease-of-build.
-
Version formula to work on single Line Items
Allow the usage of a Version formula in the Blueprint view of a module to work on single line items, as compared to the current state of working with a LISS. The usage of a LISS makes it more difficult to maintain if i need only one calculation to abide a specific logic, and creating a LISS for one formula change and…
-
Prepare Sets of Dimensions and Subset Intersections of those Dimensions
As a model builder dealing with combination master data (Cost Center x Cost Element, Revenue Categories A x Revenue Categories B x Revenue Categories C), I want to be able create pre-defined sets of dimensions, the intersections of which I can subset, so that I can easily apply these sets to a module and save space by…
-
Turn Off List Aggregation Function Work Around ?
Dear Community, I have a list A: Employee List, which is parented by List B: Department List. Anaplan automatically aggregate input to List A to List B. However, I have a situation where I want to turn off the auto aggregation and aggregate List A input to List B using a "SUM" formula. The reason is that the parent/child…
-
SUM by text Property: Calculation function
Hi All, I have a List Dept L3 where I want to SUM my $ Values in a module by its Code i,e not a Code of my item but a text formatted property which says Dept Code. I want to apply Sum by 'Property code'(830) in a list as shown in attached snapshot. Highlighted items are child of different parents. 830 is the Property code…
-
List referenced by DB
Hi, I'm searching which DB the Lists is referenced by. We can confirm the module which is referenced by DB. How about List?
-
ACTIVITY 6.8.2
Hi! I have reached lesson 6.8.2 and I am stuck on the 3rd Time sheet for Regions. Each time I try to enter the formula for code in SYS02 it says "code" does not apply to any lists (it has an empty Applies To) Does anyone know what to do? Thanks! Maira
-
Formula to hard code list item
Hi Experts, I have two modules. Module 1 has got lists: Cost Center, Cost Element, and Time. Module 2 has got lists, Cost Center, Cost Element, Time, and Profit Center. I need to bring data from module 1 to module 2. Whatever data will be coming into module 2, will be stored against P9999 profit center. Rest other list…