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 mo…
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…
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…
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 …
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…
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 Cate…
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 al…
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 M…
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 Anapla…
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 mapp…
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 m…
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…
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…
Hi I have this scenario where I need to bring in data from a source which is dimensionalized by Product L3 (leaf) level and Account to a target which is dimensionalized by Product L3 (leaf) level and …
Hi, I want to omit calculate Lineitems by using Lineitem subset. I have these Lineitems. I have to calculate each(A,B,C…) error(= Forecast - Actual) . But in this table , I have to create at least 4Li…
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 summar…
Hi Community!! I am having issues in one of my Modules and Page, as I need to filter out groupings of Country/Region/Area depending on the Territories the user has assigned. Can anyone provide advise?…
