-
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…
-
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.
-
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.
-
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…
-
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…
-
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
-
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…
-
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…
-
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…
-
calculate time settings with out hard coding
HI All, I want achecive below attached scenario without hard code. in source if i enter y the result should be start week and end week start week can find out by current period () and how can i find out end week without adding +52 or 53 same applice to below scenario y-1
-
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…
-
Management Reporting Example
-
Can Data Hub hold formula related data? or just the spoke model is supposed to that?
-
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?
-
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…
-
Help on P&L What-If Optimizer
Hi Everyone, I'm trying to build a Simple Optimizer for P&L where Variables are Volume, Selling Price, Cost Price and Objective is to get a Particular Net Income. I'm getting errors and unable to move forward
-
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
-
Can we assign access to Actions in Production the same as we assign roles to production?
Hi, Not sure if this has been submitted before but I quickly searched and could not find any. Problem: Can we assign access to Actions in Production model? Sometimes, we need to create new actions and we need to assign access to those actions in development model, so when sync to production, the roles can access those…
-
Limiting Cells to Specific value
Is there a way to limit the value of a cell to a specific range, say between 0-100%. The end desire is for anything input that results to a total exceeding 100% to cause an error or a message for the end user.