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 o…
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 i…
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 tha…
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…
