-
Count the number of users using User list for every months.
Hi All, I would like to take a count of the users using the list Users for every month. I have a module with: Row: Users List Column: Time(Month) Line item : Number(whose formula is 1) I need to sum the number all all the users for a particular month for eg for Jan sum of users can be 74.
-
Line Item Subsets and Summaries
I'm running into a curious situation where I'm trying to use the Summary of a module that includes a Line Item Subset downstream in another module. I'll walk through the situation below. I built a single module to drive my line item subset, and I created a "top level" or summary item: I created a line item subset that…
-
Avoiding a Circular Reference when pulling the previous day from the same LI
Hi, I'm trying to find a way to pull for the previous day, while skipping over weekends and holiday's, for the same LI. Below is an example of the formula I'm trying to do, but I get a circular reference. This formula works if the LI is from a different module, but I need to be able to pull the previous day for the same LI…
-
modules properties documentation
I am unable to find Anaplan documentation on some module properties like user list, parent, is summary, code, brought forward and start of section and their use cases . It would be great help if anyone has link on documentation related to these properties and ideas on their use case.
-
How to ramp up to understanding an Anaplan ecosystem
Hi All, What are best practices / tips to ramp up to an Anaplan ecosystem. I received my Model builder certificate and have a good grasp of the system terminology. I recently was brought on in the middle of an Anaplan project and having difficulty ramping up to what all the build activities that are happening are. My…
-
Using a subset vs boolean
Hi Everyone, I was wondering if it was possible to have the box to select a subset for list to be shown in the UX? For example I have 2 subsets, CAPEX, and EPMO, among the project request list (where project planners can request projects for the budget cycle) and want them to be able to select if it is a CAPEX or EPMO…
-
How to calculate within the list items to get the maximun of the items from the first to current?
Hi everybody! Need help to do the calcution within the list. Here is a list with items(#1,#2,#3,...), and properties of Input and Output. The Output is supposed to be the maximun value of the input from #1 to the current item as below table. Anyone has solutions about this? I found it difficult to calculate list…
-
how to rexecute this correction
Hi Community, Below is the screenshot of the column Revenue Actual CY. As you can see the Net Operating Expense (income) line has a value of 285,480,176. It is the sum of Corp Service Income until Quality Mngt. How can I make the value of Net Operating Expense (Income) the same as the children 71,370,044. I tried replacing…
-
How to achieve Different Granularity in a line item based on the version?
Dear experts, We have a requirement to have to different granularity of data in a same line item based on the version selection. Detailed explanation: The line item has following granularity of data: Version = Actual; then the granularity becomes Potline (Parent of Potline Group, This data comes from Data Hub). Version =…
-
Forecast in foreign currency - do others do this?
We are beginning our initial Anaplan build now for forecast, and we're trying to determine the best way to dollarize our unit forecast in appropriate foreign currencies and then roll up to a USD forecast. We're working with a business partner to implement, but our internal IT team is questioning if this is core Anaplan…
-
Can we have 2 DCA for one line item?
Scenario - At the UX level , a user will come and input a value in the line item(For example KPI). This KPI is different across different geographies. So a user can only edit KPI from his/her region. In order to do that I set DCA at the KPI level. Now once the user has put the value, manager will come to review and if all…
-
DATA IN MONTHS AVERAGE OF 4 MONTHS REQUIRED
I have a query, that i am having data in months and count is the line item.how can i average 4 months of that data. Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec FY22 120 123 140 145 150 60 70 80 86 78 79 80 ---- so Iam excepting output Average of 4 Months? Jan Feb Mar Apr ? ? ? ? And what format can i take for this of…
-
Change Order and Style of Line Item Subsets
Hello, I am looking for some help. I have a module, call it "Module A", which feeds a Line Items Subset, call it "LIS A". I used the "LIS A" to populate an end state report, call it "Module B". How can I change the order and styles of the LIS A points in Module B? When i make the edits (reordering of lines or changing…
-
FINDITEM multiple columns
Hello All, I was wondering if there is a way we can use FINDITEM to find a value from multiple columns. The way FINDITEM works is by comparing a list with a specific line item (column). However, in this case, I need to be able to find an item that may be in column 1 or column 2 or 3. Is there a way to achieve this? Any…
-
How to do Excel Search in Anaplan
Hi Anaplanners Has anyone built an Excel Search function equivalent in Anaplan? What I would like to replicate is: 1. Client has a text mapping table (screenshot 1) which maps Strings in Column B to their expense classification (Column C & D) 2. SAP extraction which contains a column called Text (screenshot 2) , Column H.…
-
Disaggregation
Hi Experts I want to Learn About Disaggregation can You Please Guide From Where I can Learn . Thanks In Advance .
-
Is there a way to turn off the calculations done on Summary Methods in Snapshots?
Is there a way to turn off the calculations done on Summary Methods in Snapshots? Currently I am having an issue with the rollups on the snapshots because of the Summary Methods on the Snapshot module. For example: a line on a module has summary method of 'Formula' but the Snapshot has a method of 'SUM' so this is causing…
-
Formula and Ability to Edit
Hello, is it possible to have a formula that is formulated for a certain version or from an IF, but then allows you to hard code if that is not true? For example if we were to say "IF ISACTUALVERSION() THEN 0 ELSE {Ability to hardcode here}" Thanks in advance
-
Line item subset for %, Only one line item subset is allowed
Hi Anaplan Community, I want to leverage line item subset to create a summary view of headcount data for the total company. The way headcount is disaggregated varies depending on the business unit (sites, center, SCL) * Site headcount is divided into facility non-enabling functions and facility enabling functions. * Center…
-
How to link a property/line item on modules with different dimension
Hi, I need to get data from a line item from one module with a different dimension with my target module, I cannot do a lookup because the 2 dimensions are not totally related. See details below ; I need to get the Position value from the source to the target, as you can see in the target module, not all Position list is…