Modeling

days linked to 4-5-4 calendar type
Hi, beginners question. I have a model with calendar type 4-5-4. I want to register actuals and forecast on a daily level for the first couple of weeks. I did check out the video on mixed calendars in this forum, but wondered wehter there was not a simple solution. I just want to record on the versions ( actual and…
Anaplan Administration
Summary: Anaplan Administration enables you to streamline user access and model administration across your entire Anaplan footprint. This feature allows your customer-level administrators greater governance and control, giving them the ability to implement user changes and organize models across the enterprise. Course…
Mapping Line Item Subset to G/L account
Hello, I'm working on a test to get T&E data that is pulling from an input module into the "Collector" module(using a line item subset) to then map to the actual accounts in a P&L. The collector module has two line items Data (which is Collect) and mapping. I formatted the mapping item as the "Accounts" list, but I wasnt…
Need more clear error messages
Error Message "Item X cannot be removed from Subset Y because it is referenced as a selection from Subset Y in the formula for line item Z". This error message essentially means that the item in the SELECT clause was not a part of the subset in the "Applies To" of the source line item. Have you guys (other model builders)…
How to delete an list item that is specified via REST API?
We are trying to figure out how to delete a item in a list that is specified via the REST API. I have figured out how to create a control module that selects items in a list via a line item formula, create a Delete action that uses this control module, then invoke the Delete action from a REST client. (Each line item is…
Matrixmodule
Hi all, I have a numbered list where I imported data from staffcosts. My model contains this hierarchy: Staff, parent is Costcenter, parent is Financial controller. Because people are moving from one costcenter to another the staff's parent is updated monthly. But when I go to the forecast module I only want to see the…
how to add/remove list from existing Module?
Hi, I am trying to add/delete lists from modules. I am not finding an option to delete the list & at the same time i can't inser new list to the module. Everytime i am deleting the module to make any changes to the dimensions. Please advise on this. Thanks, Sangeetha
STANDARD DEVIATION
Is there any function in Anaplan to calculate Standard deviation. In excel there is a function "STDEV". Need to get the standard deviation for a product across 36months of data.
Sum of forecast months entries
Hi, Could anyone please help me to understand, is there any way in Anaplan that we can sum the forecast months entries. For example, I have a user input dashboard which contains the future months. I have to sum the user entered values only for the forecast months. The sum should restrict within the forecast months.…
Line Item or Line Item Subset or Line Item Subset mapping to Accounts
Hi, Anaplan friends, In the attached file, there are three options for simple P&L by Stores. May I know what factors need to be considered in choosing one out of these three options ? What determines which option you should choose ? What motivates you to apply option 3 where you need to take three steps to derive ?? Your…
How to set a boolean property for one (and only one) list item ... be like a radio button selection
I would like to allow a model user to flag ONE member of a list as the "base item". If the user changes a leaf-level list item's "base item" flag to TRUE, then all other leaf-level list items that were previously marked TRUE should be marked FALSE. One and only one item must be "base item" = TRUE at any given time. (Use…
How can I switch a list that is already been used in more then 50 modules and a hundred of formulas?
We had an update on our distribution channel list, so we need to create two more hierarchy levels. The problem is that this list is already been used in more than 50 modules and a hundred of line items. We're having some troubles to implement this. Someone knows if there is an easy way to do that or we need to delete all…
Model sizing
How to calculate model size in MB at Anaplan workspace? What size of list item? What size of cell in module? How to plan future expenses for Anaplan?
How to aggregate the "same" month data from different years (Seasonality Calculation)
Dear all, We have a scenario which is to calculate the seasonality % based on the past 3 years' actual, and the seasonality is applied for the planing of the next four years equally. For example: FY18, January (Seasonality %) = FY19, January (Seasonality %) = FY20, january (Seasonality %) = ( FY14, January + FY 15, January…
Formula clarification required
Hi, Can anyone help me out on understanding below formula what exactly it drives ? Import Rebate Actuals.Gross Sales Amount[SUM: Import Rebate Actuals Map.Reporting GroupProductCustomer List, SUM: Import Rebate Actuals.Contract Name, LOOKUP: Reporting Contract Stage One.Contract Map] Thanks, Satish.
Conditional formatting on variance versions
Hi, I would like to apply conditional formatting on a dashboard. I have a module based on 3 versions. -Actual -Annual Plan (AP) -Variance Variance = Actual - AP Now the conditional formatting should be green if the Variance >0 and red when <0. However when I apply conditional formatting all versions will be formatted. I…
Circular Refference - using prior month value
Hi everyone, I'm having troubles creating a module that recalculates a regression each month. My regression is based on values of the last 12 months. When there are no 12 months of histicorical data available, I want the line item to use the previously predicted values with the regression as input for future values. This…
Long date format
Hi everyone, Apologies if this has been asked before but I couldn't find anything in my searches. Is there no way to have a 'long date' format for days, eg: dddd dd,mm,yyy Thanks in advance! KT
Using RIGHT function with a list
Hi, I have a field that is a list format (itemcode), and it has a 3 letter code at the end of each item (e.g product1-abc123-regular-CNC). In another field i want to check this code before carrying out a calculation. IF RIGHT(itemcode,3) = "CNC" THEN 1 ELSE 0 I cannot use RIGHT(itemcode,3) as it is not TEXT, how can i use…
How can I use Rank if I have more than 10000 group in a list?
Hi, I have a long list that has around 30000 line. soem of lines are duplicate and I need to deperate them. I wanted to use Rank function and group lines base on a property but I have 17000 actual group and Rank limit for group is 10000. How can I solve this?
Disable 'Show All' option
Hi experts, Do you know any way to disable 'Show All' option for List Item with Selective Access? Best regards, Tatsuo Oba
Only show year total with time filter module
Hi, I built a time filter module to show only current year and prior year monthly revenue. Also, I want to show CY and PY total. However, when I changed the summary setting to show sum, it shows quarterly total as well. Is there a way to only show annual total, but not quarterly? Thanks a lot!
Data Mismatch while fetching the data from one module to another
Hi, I was facing an data incosistency in few of my modules. Here in my model, "Import Rebate Actuals" is the module which drives data into rest of the modules. "Import Rebate Actual" is a module which has proper data init but while fetching this data into other modules then the data in fetched modules gives us inproper…
Subtotal visible items
Is there a way to add a subtotal item or function? Currently we have a list with 15 members in it under one parent. Most users have read access to one item, others have access to 2 or more, a small number of users have access to all members and the parent. For users that have access to 2 or more, they can’t see a subtotal…
Composite vs general organization hierarchy
Hello, I'd like to hear experiences from others of modelling complex organization hierarchies. Often the decision is to choose between composite hierarchy and general hierarchy in one list. Usually I prefer composite hierarchies but always it is not wise, right? Case that I'm thinking is an organization that has quite a…
Comparing the sales line item of a similar kind of product
I have a list of products and few of those products are new to the hierarchy with no history. In this case i need to compare and refer from SALES line item' of a different product from same list. * I have only 1 product hierarchy list to use and it has associated sales, cost, profits,etc with it. * Few Product has similar…
Top down allocation
Hi, We have a requirement where we need to capture macro-economic demand % at Region (Parent level) and the same % should be allocated to its children. Eg : We have list Region with UK as parent and UK-MSO and UK-FS as zero level (child) members. We need capture macro-economic demand % at UK (parent) and same should be…
Alternative Hierarches
I have a P&L 1 that has being data input into it using a list Organisation 1 as its hierarchy. I require the same data to be pulled into a similar P&L which is using a different list Organisation 2 as its hierarchy. Both Organization lists have the same Codes against each reporting entity, but they are grouped undrer…
Time filter for users on Dashboard.
I am trying to set up time filter in such a way a user must be able to select start month and end month OR Every spring has 6 fiscal months or fall has 6 fiscal months What would be best way to do and how ?
General Question About Numbered Lists
From what I have read and seen Numbered Lists are used predominantly to reduce sparsity, i.e. when you have a lot of cells in two dimensions that are not ever going to contain data. My question is however, what other uses are there for numbered lists? Are they used to manage a situation where there are duplicate names in a…

Modeling

Discussion List