-
I want a formula for Boolean line item as true for below requirement. How to do that?
.
-
Does Anaplan allow different formula for each versions?
Hi! For example I have 4 versions namely: Actual, Budget, Forecast 1 and Forecast 2. Does Anaplan allow different formula for each version I have in my module? Say, Actual version will have a different and unique formula with Budget, etc for the same modul. Thanks for any help!
-
Anaplan Percentage Format Issue
Hi All, I am trying to calculate the Compound annual growth rate (CAGR) in Anaplan and I am getting a 100% instead of 1%. Here is the formula logic in excel =((Z84/C84)^(1/23)-1) The first value is cell=(C84) January 2021 value = -167,217 The last value is cell=(Z84) December 2022 value = -136,485 The Cost values go across…
-
HiI want to use quarterly sum in another module which is in months. How to do that?
-
Level 3 Sprint 1 3.2 Model Build Specifications
Should I be creating a separate module for the Volume Growth rates by country and then using a lookup to pull in the requisite %'s into the TRA01 module?
-
Is it more efficient to divide by 1,000,000 or divide by line item of 1,000,000
Hi I am building an output module and need to divide everything by 1,000,000. Is it more efficient to just put / 1,000,000 or / S01.oneMillion? See the ss for an example of one of my formulas Thanks
-
Concatenate multiple items
I'm slightly confused on the best approach to concatenate multiple items into a single text line item (where neither is a code or part of a list) For example lets say I have a module with the following line items T1, T2, T3, T4, T5, T6 and T7 and Concat line item is C1 Currently C1 shows: T1 & "_" & T2 & "_" & T3 & "_" &…
-
Mgmt Reporting: Table Card Variances
Hello, I'm new to the "management reporting" feature and am hoping someone can please help me with Table Card Variances. Is it possible to calculate the change in basis points between two percentages? Thank you, Amy
-
How to pull previous year end balances into a monthly calc
Hi So I am having a bit of an issue I need to do a calculation monthly, but I need to refer back to the previous year end balances as my start point for all months. I tried doing it with offset, why I take a starting balance for that month, and then offset everything back to December to lookup the amount needed in my calc,…
-
Will change in code disturbs the data it holds?
Hi, I have a numbered list and a hierarchical list that holds important data. Now I have a requirement to update a few existing codes of the lists. I tested using a dummy list and the data was not changing. Want to double-check with the community if I change the codes of the lists mentioned above lists hope It will not…
-
Define current year end week
Hi all, How can i define CY end week by formula not hardcode. we dont want to use CY week +52 so any Suggestions
-
create a home page in Anaplan with navigation buttons
Hi all !! Is it possible to create a home page in Anaplan with navigation buttons? If it is, could you please provide instructions on how to accomplish this? Thank you.
-
I want Booleans as true as per below requirement
-
Source Label change with change in model in Imports.
Hi, I have a model - Model 1. I took a copy of the Model 1 and named it Model 2. Now in the Import section of Model 2, the source label has still the name Model 1 in it. So, wanted to know when we run the action will it be from the same model Model 2 or it will be from Model 1 from where I copied it. Thanks.
-
3.4.3 Activity: Create Country Summary Module
I have created the module as requested and added below formula, however there is no data reflecting in my INV02. Can anyone suggest where i am going wrong? SYS08 module snip INV02 module formula INV01 snip where my stockcount is shown as 0 completely. INV02 is shown as 0, not sure of error. Kindly let me know, thanks for…
-
Summary Method Issue
Hi Community, I'll try to put this in excel to describe my problem better. To explain the excel better, I have Region and Status title at page selctors, I have line items in column and Org L1 at Rows. Now Line item 1 already has a formula and its summary method is formula too. In line item 2, I want sum of only positives…
-
Moving Average Issue
Hi, For my Forecast Jan 2023 I want to bring the (Actuals) AVERAGE of Jan 2021 and Jan 2022. And for my Feb 2023 I want the AVERAGE of Feb 2021 and Feb 2022, e.t.c. To achieve this I split the line item actuals values into the ones below, for calculation and then bring it to the forecast. for 2021 Values line item for 2022…
-
SUM IF Anaplan
hi there, I would like to build a report which would basically be a P&L where I display the cost per segment in 1 table. My segments being a grouping of a list (departments): my "base" P&L looks like that: and the report I would like to build should look like that: The idea would be to fill in the cost lines (Human…
-
Create DEM03 Demand Forecast Module
I am really stuck with the formula to be used in this module. Would really appreciate help if someone can guide through detailed formula
-
Get Maximum number against year in a transaction data?
Hi, I have transaction data where i have a period formatted line item with the year and a number formatted line item called Number. I want the maximum number against each year in the Max column. I tried the Number[MAX:Year] but it didn't work. So how can I get the maximum number against each Year? Attaching the screnshot…
-
Can Data Hub hold formula related data? or just the spoke model is supposed to that?
-
Variance Report Issue
Hi All, I am creating a variance report using a custom list mapping to a native list in order to bring the data to the module with fake list. After I sum it I noticed the Actuals data is not flowing in the actuals for the target module but in one of the version only, And other versions afre not flowing to the target…
-
How to Use DCA to deactivate boolean selection?
Hi Community I have 2 list. List A & List B. I have created one module using list A and there are two line items Product Family (Formated as list B) and Applicable?(Boolean). I have to disbale boolean if I select Appliacble aginst other list item if I select A(Other A should be not accessible) while I can tick boolean of…
-
Boolean Processing Optimization
I had heard that removing IF THEN ELSE from boolean formulas is more efficient. For example: a = 1 AND b = 2 is better than: IF a =1 THEN IF b =2 THEN TRUE ELSE FALSE The reasoning I was given was that Anaplan will process conditions a and b in parallel for the first formula, but sequentially for the second. Is this true?
-
Management Reporting Example
-
Doubt in Modeling: Team + User + Project + Project Category
Anaplanners, Summary of items: P1 Project List # (List of projects created in the system) A20 Fake user List # (Custom built users List) A10 Team List (Teams within the organization) R3 Project Category List (Important, Not Important, Semi Important) 1) Project Category is an attribute of Project List, this is assigned…
-
How can One Create a Dynamic Movingsum
Hi, I'm doing a movingsum and what to achieve these set of rules. IF Actuals then movingsum(data, -11, 0, average) else IF Forecast I want to do for Jan 24 movingsum(data, -10, 0, average), for Feb movingsum(data, -9, 0, average) for Mar movingsum(data, -8, 0, average) and so on How can I achieve this in one line item. I…
-
Level 2 - Sprint 1 Activity 1.3.6.4 Create Import Distribution Center Details Saved View
Hello, For the SYS07 Location Details I believe we need to have some formula to populate this table. This is a little tougher because these are flat lists that are not linked via hierarchy. Can anyone guide me help how to generate the country, region and distrubtion center in SYS07 ?
-
Assistance needed adding a column filter to a UX custom view dashboard
I'm trying to add a filter to the columns of a UX custom view and not getting the expected results. Any assistance would be appreciated! Purpose of model – allow users to allocate employee salaries to multiple locations. Model hierarchy: C1 Company C2 Balancing Unit C3 Cost Center C4 Provider (these are the employees) We…
-
Boolean with summary : "all", true for parent with no child?
Why is a Boolean line item with summary set to ALL true for Parent even when there are no child items? I noticed that a boolean line item was true for a parent in the hierarchy automatically if summary was set to ALL even if it had no children. Why is this so? I thought if summary is set to ALL the parent would be true if…