-
6.6.3
In the first image, you’ll notice I tried following the instructions, which are highlighted in orange and blue. However, in the second image, you’ll notice my results, which are highlighted in red, don’t match the video’s results, which are highlighted in green. NOTE: I highlighted two discrepancies. What am I doing wrong?
-
8.5.3
How do I shift the "Time", which is highlighted in red, down one row?
-
Consistent Y-Axis Scales Across Multiple Charts
Hi, Fellow Anaplanners, Could anyone provide guidance on how to configure two distinct charts so that they share the same scale on their y-axes? This is necessary for ensuring a consistent and accurate comparison between the datasets represented in each chart. What are the steps or settings adjustments needed to achieve…
-
No of sums in a single line item
Hi, Need to know that how many number of sums we can use in a single line item so that its performance will also won't downgraded. Thanks, Vicky
-
Top Level Item Filter to Show Subtotal
Hi All, I have a module with a composite hierarchy below. I would like to filter with a boolean line item for all countries in the Americas and get their total 50 show in the ALL Regions (Top Level Item). Also when the filter is applied I want the ALL Regions (Top Level Item) to show in the list items. How can I achieve…
-
How do I see true boolean across multiple users?
Module #1 dimensioned by 1) User and 2)Category I thought this would be simple lol but I have an Anaplan module dimensioned by users and category. Under my user i have a Boolean line item called sent for approval as true for one of the categories called refrigeration. Another user has the category "Cooking" as true. I want…
-
How do you import line items from one specific list in a module?
Hi, I want to import data from a module contained in another work space. This source module only has one list with no top level. Specifically, I am trying to import the line items from one list item "Cost". On my attempt, I tried the following steps: Pivoted the list item needed as a page, and the line items in rows…
-
Can we sort data in Anaplan with time?
Hi all, I want to sort data in Dashboards using time, showing the current year 1st and then followed by previous years, is that possible? Thanks in advance.
-
Level 3 Sprint 1 - 5.2 PY Account Revenue
Hello All, I have stuck with formula for 'PY Account Revenue' in 'TAR01 Detailed Sales Targets'. Looks like formula: 'DAT02 PY Revenue to CY'.PY Sales Revenue[LOOKUP: 'SYS03 Account>Product Details'.'A1 Account'] is not correct, because I have incorrect numbers in Check module. Can anyone help with correct formula for that…
-
Help with Formula LI 'Currently Optimized Through'
Hi, I'm trying to create a formula that will pick up the first day when the LI 'Y02 Accounts (Forecast)'.'Closing Balance (01)' is less than 1 million in the forecasting days. The formula below is what I created. It is not pulling in a date. Formula IF 'Y02 Accounts (Forecast)'.'Closing Balance (01)' < 1100000 AND 'S01…
-
Sum and Lookup using 2 mapping tables
Hi All, I currently have a module with 2 lists with data that need to be in another P&L list via 2 mapping tables using a methodology. Source Data dimensions: List 1, List 2, Time: Month Target P&L dimensions: P&L List, Time: Quarter This is the methodology: * If List 1 Mapping Table.Methodology = Methodology List 1 then I…
-
Private Equity _ performance fee and carried interest calculations
Hi presently I’m in the process of building a hybrid waterfall calculation model —- where I need to show both portfolio company information as well as Investor level carry calculations. I build modules surrounding investor level carried calculations - should I proceed building out modules to incorporate the positions as…
-
Workaround for Parent Child Relationship for Boolean Lookup
Hello, I am trying to do a workaround where I am not able to directly map a Parent and Child relationship but the users would want to be able to alert owners of a subsidiary account living in a different territory that they want that subsidiary to follow their HQ account. A specific example would be: Account 1 HQ has 4…
-
What is most computational demanding on the system, if statement or max formula
Hi, I have a question, I have encountered in some of our models, where we want to limit a value to be 0 if it is negative. The way we have done this so far is by making an if statement so: if A > 0 then A else 0. Since Anaplan has Max, I thought this could be used, at least to make it easier to follow. The big question is…
-
Updating time dimension to the correct dynamic formula
For this individual above, he started on December 2024 (H1 FY24) but the way I have the time settings set up it is 1 year before and 2 years after the current year and it is making this person start their proration at the beginning of the model calendar as opposed to their actual start date. I am trying to use these…
-
Сorrespondence of a number to a numerical interval from the List
How can I match a numeric interval from the List to a number in Anaplan? For example: Interval list: 1 - [name: "<=80"] (min = 0, max = 80) 2 - [name: "80-90"] (min = 80, max = 90) 3 - [name: ">90"] (min = 90, max = 1000) Number = 83,257 - it should correspond to the interval No. 2 "80-90"
-
MOVINGSUM Formula
Hi, I have a snapshot of what I require done in excel but can't get the MOVINGSUM formula to replicate this. I have Pass Sales on a Generic Weeks Timescale model. The pass is then spread out by the number of days in each week that it applies to. Basically I'm trying to defer revenue over the time of the pass. Sales in the…
-
Level 3 4.6.5 Sale Planning Model: DAT02 module
I have tried to formulate the PY actual sales revenue as 'DAT01 PY Revenue'.Revenue[Lookup: 'SYS00 Time Settings'.PY Qtr,Lookup: 'SYS03 Account>Product Details'.'A1 Account'] Below is my screenshot for DAT01 whereby I imported the numbers from DAT05 in Datahub. Below is my screenshot for DAT02 module: However, I received a…
-
Level 3 4.6.5 Sale Planning Model: DAT01 module
Hi Community, I was wondering if I did my DAT01 correctly? Because to import DAT05 historical sales from Datahub to Sales Planning module, I will need to set both dimensions as A1 Account and P2 Product list. However, when I start to build DAT02, my dimension was A2 Accounts>Product list (according to the learning module)…
-
Level 3 Sprint 1: SYS03 Account>Product Details
Hi Community, I was wondering if I have missed out something here. Why P2 Product column did not get populated.
-
Saved Views
Hi All, Can you please help me to understand visually what is the difference between system module and saved view as per below instructions :- SYS05 Saved View :- Let me know please if i am doing any mistake ? as in furher topics if i am importing these saved viewes I am not getting any data populated in lists.
-
Check if a product belongs to a subset of products
I have a product list with a subset for a particular type of products (e.g., sweets). I have another module that is NOT dimensioned by products; however, product is one of the columns. I want to create a line item that returns true if the product belongs to this subset. How do I do that?
-
Add new line item to import action
Is there a way to add a new line item for a source module into an existing import action? I have created a new line item 'X' in both the source and the target module. The new line item 'X' appears as an option to map to in the target module when editing the action, but it doesn't appear in the source module list to select…
-
Seeking Guidance on Dynamic Addition of custom Planning Versions in Anaplan
Hello, I am currently working on dynamically adding planning versions to my Anaplan custom planning version list at the onset of each new month. To achieve this, I am in the process of creating a corresponding workflow. The challenge I'm facing is that the details of the next version are stored in a module. I need to fetch…
-
2.3.9.3 Update Historic Volumes for Baseline Forecast
Hello everyone, I encounter a problem concerning the formula of "Offset Volumes for 1st Forecast Year" . I wrote the formula that seems logical to me but it doesn't work. Can someone help me correcting it ? Thanks in advance. N.B : The first image represents hints for the formula and the second image is the formula that i…
-
Do ignored columns (from imported files) take up space from my model?
Hi guys! Do ignored columns (from imported files) take up space from my model? Thank you very much!
-
Seeking Insights on seasonal forecasting within Anaplan: Share Your Experiences and Best Practices!
Hello Anaplan Community, I hope this message finds you well! As we approach the holiday season, I am eager to learn more about how companies in our community are leveraging Anaplan for holiday forecasting. This is a crucial aspect of planning for many businesses, and I believe there's a wealth of knowledge and diverse…
-
Version ?
Hi all, I have a model and i need to Visualise my Company's sales history, Forecast compared to actual. input history sales for the year 2022. Calculate Bidget for the year 2024 Artual periode : septembre 2023 Is it possible to use versions to achieve this, and if so, how? I haven't worked with versions before, so I'm not…
-
Can't add a parent to a existing list
Hi all, I am having some troubles adding a new hierarchical level to an existing list, which is called BU01 Business Unit and it's not a numbered list; the new parent should be BU00 Business Unit Combine: If I try to compile the parent hierarchy column, I get this error: If I try to delete All Business Unit from the Top…
-
How do we make a scatter plot
I have configured the table row order so that the first 3 columns are actually the right data but it keeps stopping me from creating the charts. Any reason?