-
How to make Date as a Display name in a Numbered list?
How do you make a Date as a Display Name in a Numbered list? I added a formula into my list properties with the format set as Date and the formula referencing the numbered list and the Date field. It pulled in the number properly to the Display Name. However, the new item created in the list is still a random number and…
-
LOOKUP does not work on list parents and only leaf items
When a LOOKUP is done on a parent item in a module, the result does not resolve to the column with that respective parent. Subsequently the value shows 0. To reproduce: 1. Create list with leaf item and parent 2. Create module with column 1 as "Data", column 2 as "Parent", and column 3 as "Lookup", using list from 1. as…
-
Parent-level Commenting with Line Items Pulled from One Module to Another
I have a question about parent-level commenting with line items pulled from one module to another. There are line items in module 1, which are pulled into module 2 via subset and transposed into rows. In the screenshot, you’ll see ‘Salaries & Wages’ is the sum of ‘Salaries’, ‘Overtime’, etc. There’s a ‘Key Highlights’ line…
-
Excel user defined functions
If my Excel model has user defined functions, ie multiline VBA functions that are called by worksheet cells, can Anaplan handle them? I could not find anything about them online thank you
-
Error : EMP02 - Dimension of mapping used for lookup doesn't match any dimension of the result.
Hi Experts, Please help on the below mentioned issue while adding formula for Bonus, Car, Phone costs & Medical costs to the EMP02 Module. BonusIF Employed? THEN Salary * 'EMP01 Employee Drivers'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Country] ELSE 0Car costsIF Employed? THEN…
-
List Inheritance
Where lists are in a hierarchy, it would be really helpful if Anaplan natively understood the concept of inheritance. Here's an example. Consider two lists in a hierarchy: * L1 Countries * L2 Cities L1 Countries is the parent to L2 Cities. Within an attributes module, each L1 Countries list item is assigned a currency.…
-
Forward Weeks of Cover or Forward Weeks of Supply
Thought I would post this here as a method to calculate Forward Cover or Forward Weeks of Supply. A year ago @AnaplanIdeas posted an idea for this which is great. I'd like to expand on this idea and also incorporate @nathan_rudman backward-looking suggestion. Summary: In the supply chain horizontal you may be asked to…
-
Time Filter applies to specific month
Hi, I'm trying to create a time filter that will only ever return current month and December 2020. I've managed to create a filter for both using separate line items, struggling to combine and allow users to view. Any suggestions? Thanks.
-
Circular Reference when using a line item as input
I have a formula that needs to look a specific number of months back. The formula works when I type in the number of months as a hard code in the formula, but not when a use an line item containing the number of months. A screenshot is below. The Maturing Balance formula works. The Retained formula is the Maturing Balance…
-
Level 1 Model Building : Margin and Margin % in Rep02 Size Margin Report
Hello, I am reviewing REP02 Size Margin Report and having issues. The Margin and Margin % are not populating. Is there a reason this would be happening. Is it not supposed to populate? I have put in the formulas and the sums properly (see attached image).
-
Custom Time Dimension / Supply Planning on a daily basis
Hi, For a client of us we're looking into setting up a Supply Planning model where planners have the ability to plan with a telescopic view. Meaning they're able to simultaneously plan on a daily & weekly basis. Ideally we would work with the standard time but as weekends can not be taken into account we're looking into…
-
Sum Transactions Based on Properties Between Two Dates (Days, Weeks, Months)
An often requested output of a trade promotions use case is to understand sales between two specific dates— be it days, weeks, or months. The solution below has one dimension in it but would work equally well with additional dimensions, such as customer or supplier. Having loaded in the transaction detail following this…
-
Date Conversion
Hi Guys, I have a simple one to ask. I am loading a Period with a Text format to a Year and Month with a Number format. Example: I loaded a date of Jan 13 to a Period column. Then I need to convert it to Month 1 and Year 2013. I tried loading it as Time period which is the right way but for some reason it is not loading…
-
Variance Analysis between versions without using select
Hi, I am trying to create a variance Analysis for users so they can compare price & volume between to Anaplan versions (i.e Budget & Forecast, Budget & Actuals). This idea is for user to select Version 1 and Version 2 to decide which versions they want to compare. Similar to: Select V1 : XX (i.e Budget) Select V2: YY (i.e…
-
Set default file to everyone
Would be really handy if Anaplan did either one of the following actions for import data sources: * Set the default file type as everyone or; * Permanently saves files regardless of default file type selected. This would really assist in debugging and remapping import files.
-
How to calculate cumulative results
Hi,everyone. I would like to calculate the cumulative result of a line item. I think I should use the TIMESUM function, but I don't understand how to use it. I want to get the cumulative result from the date of FROM to the date of TO. Could you tell me the best solution? Best regards. Taku
-
nth occurrence text function - finds nth time a character occurs in a string
I would like the ability to use a function that allows me to search for the nth time a character or string of characters occurs in a concatenated key. Currently, we import text string keys from source systems and derive business information from these strings. For instance, we might have the transaction key…
-
QUARTERVALUE Function
Hi team, I've got 2 simple modules with 2 dimensions, Accounts & Time. The source module has the Model Calender with Month as the Time Scale. The target Module has a Custom Time Range with Quarter Totals selected & has Quarters set as the Time Scale. Both Summaries are set to Sum When I reference the source module using…
-
Referencing Batches of Same SKU to calculation QTY of expiring materials
Hi All, I've been racking my brain over this one and I can't think of a good solution. I want to calculate the amount of inventory that will go expired for a given batch of materials, but as we cannot reference another rows easily like I can in Excel, I can't think of a good way to do it. Here are my basic assumptions and…
-
Using Python's statistical capabilities to Manipulate data already in an Anaplan Model
I want to leverage Python's statistical capabilities to manipulate data already in an Anaplan model. Has anyone done this before / had any experience with this? I know I can use Python as a data integration tool, but would like to also use it for calculations.
-
Input into different hierarchy level and display balances in one module with Hierarchy and COA dim
Hi, I've been digging around all the resources but could not find any solution to my problem. We are trying to build a legal hierarchy tree (ragged) with inputs into each entity in varying levels and then presenting those inputs in one module with 3 dimensions: legal entity hierarchy tree, chart of accounts, and months.…
-
Find the minimum contract quantity falling within a contract range
Hi, Hope you all are having a good day so far. I would like to identify the least contract quantity falling within a price list range. if 10 contract quantities fall within a price range then I would like to choose the least from it. The catch is that the contract quantity is a calculated value and it is calculated for all…
-
Weighted Average by variable number of weeks
@rob_marshall I am looking for some guidance on how to do weighted averages based on a selected amount of weeks? Our call center planning is in need of looking at weighted averages based on a variable amount of weeks For example, a user selects the number of weeks they want to average the results by and based on that…
-
Circular Reference Issue
Hi Guys, I need help in figuring out a workaround for Circular Reference. I recreated the modules the best I can and I hope its enough to understand. See below: This is the driver module and this is already working fine in Anaplan. Lets say Row 1 and Row 2 and then Time Dimension. This is the countif module, this also…
-
Import for Weekly Data
I am trying to import Historical Weekly Data, but am constantly getting error. Please assist how to import Weekly Data? I tried several times, I have attached Screenshot.
-
Cross Referencing Between Lists - Dimension of mapping used for aggregation doesn't match any dimens
Hi All, I'm taking our demand planners monthly forecast and converting it into daily then rolling it up into weekly buckets. I've successfully gotten us down to daily, using a fake timescale, added the week commencing date and I'm trying to do a SUM function with each day that matches the weekly period being added up. The…
-
Property in List using a formula
I have a unique key list which is a standard naming convention of 12345_123456_123456. I would like to use a formula to identify the last 6 digits that are not 000000 or 0000002 and create a list subset of those. Can you help me figure out the formula for that? Thanks!!
-
circular reference error with no time dimension used.
Hi All, I have a module without time dimension,I am facing circular reference error here: Line items used are: Total = Sum (Lineitem1 + Lineitem2 +Lineitem3) I need previous cell value of Lineitem Total for LineItem1 ie, Lineitem1 = previous(Total) As I am not using time dimension, I cant use PREVIOUS function here.…
-
How to count booleans?
Hi - I am trying to create a graph where it displays the number of items selected by the user. These items are marked through booleans. Is there a way where I can count how many items are selected per category using the booleans? Thanks!
-
Sum of amount based on numbered list.
I have a numbered list, which has the same names (display names). These same name line items then have different child. The values of the same name list items needs to be added up to only one list item which has the latest PO date in the same list. For Example- This is the source module that has the same parent names with…