Modeling

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
Dashboard View Error
Hi , we sre all getting this error on some dashboards, and can noit work out how to stop it Any suggestions please? thanks
Display the Latest Revision Tag for a Model in the Manage Models Dialogue
When you have multiple versions of a development model it is not easy to see whether the model is up to date without either opening it or trying to run a Compare and Synchronise. It would be helpful to display the last revision tag of any deployed model on the Models dialogue so as to avoid this.
Ability to add .txt file to a Revision Tag
I think it would be beneficial to have the ability to upload attachments to a revision tag as supporting information for a development change. It would not need to be any more complicated than uploading a .txt file against each revision tag. Currently, we have the ability to add a title and description for each revision…
Blueprint View of Saved View
When a saved view is open, it would be really useful to have the option to open the blueprint and only show the line items in the view, rather than the full blueprint. In modules with a lot of line items, when the view has only a small selection of them, it is time consuming to find the respective line items
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…
Anaplan to be supported in Microsoft Edge browser
I hope Anaplan could be supported in MS Edge other than IE 11 or chrome/firefox and safari. We are using edgeand we experience some issues even with just doing data entry on a field with percentage format.
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.
Is it a Bug?
I have a dimensionless module with two line items Line Item 1: Amount (No TimeScale, No Versions applied) - Number formatted Line Item 2: Absolute (No TimeScale, No Versions Applied) = Absolute value of Line item Amount Change the Formula Scope of the Line item Absolute from "All Versions" to "Actual Version" or "Current…
Migration to new SKU code
Hi All, One of my client is under IT systems restructuring and migrating to new ERP system. Because of that the SKU codes for ~6000 SKUs will change to 18 digit in a couple of month. In Anaplan we currently have old codes for SKU and there is another numbered list of SKU-Customer combination code of around ~100000. What is…
Upload - Non Mapped Source Items Identification
Hi team, Is there a way to identify Source Items in a list that have not been mapped to an item in the target for a Upload to a module in Grid Mode? I am aware you can manually identify the non-mapped items by scanning the Mapping tab but this seems inefficient and error prone (especially with large data sets). When you…
Cumulate Issue
Hi All, I just need a little opinion whether excel is wrong or Anaplan. See below. So i only copied the values so there is no formula. Excel Driver Cumulate formula it adds the Excel Source value and Excel Source Plus value. So its like Sum(Value, PLus Value). The problem that I have is in Excel Driver when they cumulate…
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.…
What's the difference between a model and an algorithm?
What's the difference between a model and an algorithm?
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…
Switchover
Hi All, Is there a way to disable switch over in blueprint view for a line item without a time dimension? Thanks N
Ability to copy a List
There are occasions when I need to have a list that is similar in structure or content but serves a different purpose in the application or where I need to have different children but similar parents in the same module. In this case my only options are to export the data, create a new list and add the properties and…
How to calculate % of one row over another row?
Hi guys, I am trying to do the calculation of % of Show Specific / Total Universe and it's not giving me correct %. In the image below, the correct % should be 5401 / 21682 = 25%, but it's showing 4800%. Can someone please advise what I did wrong? Thanks, Jim
Sum based on specific value from another column?
Hi All, For line 3 in my module, I am trying to sum ONLY the lines where Total Inventory = Regular (Dimension), how should I setup this equation?
Update/add
HI, users should add/update the changes in the module.This should reflect in the Target modules while they submit. Like if already there is employee assigned to company and again if we wanted to update the details of employee how do we do that?
Displaying Line items by user or role
Hi, I have an issue I'm trying to solve. I have a module that multiple users have access to. I don't want all the users to see all the line items. I need to hide 2-3 line items for certain users or roles. Another module without those line items is not an option. Is there a way to this? Thank you Ronit
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.
Importing data from another Anaplan model using a filter in the destination model
I have a client who would like to use an existing view in the data hub as an import, but doesn't want to bring all of the data over from that view. Is there a way they can have a filter in their model so that when the data is imported from the data hub, they don't have to do any additional processing to remove the extra…
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…
Override function to SUM function
Problem Statement: We develop a table setting out the results of transactions per code type across multiple categories (AP, AR, GL. etc). The results are calculated from detailed transactions . The customer process dictates that the amounts determined should allow for overrides to assign the amounts (all or a portion) to…
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!!

Modeling

Discussion List