-
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.
-
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…
-
List Formatted Line Item-Dependent Drop Down
Anaplanners, I have a line item which is list formatted, wherein end user selects a list item. List: R3 Category List: List Items Important Semi Important Not-Important with a top level item "All Categories". Problem: User is also able to select "All Categories", which is actually a top level item and should not be the…
-
HiI want to use quarterly sum in another module which is in months. How to do that?
-
Missing Customer from Customer Hierarchy in the Spoke Model but not in Data Hub
I have a customer that is located in our spoke model, but it is not show in our data hub where the customer hierarchy lives. There is a daily process to push the CH into the spoke model. The client also stated this customer has been around for years and should be present in the hierarchy, but the source file does not have…
-
Movingsum Function Workaround
Hi Anaplaners, I'm have 2 line items Margin and Moving sum doing a MOVINGSUM on a line item moving sum. And I would like to capture in my line item where movingsum is done. I would like to calculate MoM Average between 2021 and 2022. And When MoM margins differ by more than 30% - I will replace the value with the margin…
-
CAGR Formula Issue
Hi, I would like to write a CAGR formula in Anaplan and don't know how to go about it. Below is the formula. (Ending Value/Beginning Value) ^ (1/No. of Periods) – 1 Each time I try this formula Anaplan throws an error invalid formula. It seems Anaplan does not recognize this ^ sign. Please any workaround or suggestion how…
-
Button
Hello Everyone, I have a question. The button below "Show Accounts without Category mapping" but as you see in the table "List of Accounts and Mapping", accounts are showing up that have category mapping. Does anyone know the possible reason for this and potential solutions on how this can be resolved?
-
Dates and time intervals
Hello, I have a request from my sales team to implement a discount simulation in our sales analysis model. To be more specific. I have a model with sales data by day/customer/product. In a different model account managers will input a discount rate by client and product with a validity date, meaning I will have a start…
-
Max Value for a Line Item on a yearly basis
I am trying to find the max value in a different line item for any given year, all in the same module. time is in months so my start month would be january and end month would be december. so for 2023 I want the max item, for 2024 I want the max item, and so on and so forth.
-
How to add a button that creates a new line item in the GL that has a hierarchal structure
The current button we have in place has us add in a new SUB-GL/ vendor item to a numbered list. That numbered list uses an OpEx subset that layers in each new vendor into its respective opex area such as adding "Anaplan 2.1" under Software subscriptions in the GL. The problem im running into is that this current structure…