-
Level 2 Conclusion - INV01 Inventory Ordering not matching? Anyone please confirm
Hi All, I found that the extract "Check Your Work"(from the link) is not matching with my Supply chain model while doing training Level 2. Downloaded the csv file from L2 - Conclusion shown in screenshot Out of 371 SKUs - Beginning Inventory is not matching for 112 SKUs, while comparing FY20, FY21 totals as shown in pivot.…
-
Difference in digits displayed
I noticed that while exporting or copying the decimal data, the last digit doesn't get exported/copied. Can someone let me know if there is any limitation in the number of digits exported after decimal. As per Anaplan While exporting
-
How to Check the boolean items Based on Formula
In the source i have combo aganist the one combo item. we Have given a cycle drop down. Which consists of 8 item. If they select Cycle 1 then then Target module should be True for cycle 1 . If Cycle then Upto cycle 2 if 3 upto3. If 8 upto 8 cycles should be true . how can i achieve this in similary set up or in different…
-
8.8.4 Activity: Add Formulas to Size Margin Report Module
When I change the filter from "US" to "Americas", the data become blank. Does anyone know why this occurred? Please let me know if additional info is needed.
-
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…
-
Problems with OAuth Token Configuration
Hi all, it has been a while since my team and I have been trying to perform the Anaplan Connect Token configuration correctly. This one time, it seemed to be working for the first run, until I found out that the batch file runs correctly a second time only if remove the JKS file naturally generated in the user's folder…
-
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…
-
Design and Develop
In the Discover section, you explored important foundational resources available to you to get started on your model-building journey. In this section, you'll find resources to support you in the next level of designing and developing in your model. Get your build on (quickly!) We're developing ASAP 'recipes' to provide…
-
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…