-
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…
-
How to create and use a List with Number of weeks to each Fiscal Month in the module ?
I created a list "Months Flat" (Jan--Dec) with Top Level as 'All Months' and added Property - 'Number of Weeks' and assigned values tothe property -- 445445454445. Then I am in a module, I need to Lookup at the 'Number of Weeks: For example: For every April irrespective of Year like Apr16 or 17 or 18, it should show me…
-
Any Excel equivalent for Match function with Match type 1 or -1?
we have Excel Match formulas which looks thru a lookup_array 1) which finds the largest value that is less than or equal to lookup value (match type 1) and 2) which finds the smallest value that is greater than or equal to the lookup value (match type -1) Eg. of Usage : Supposing we have tank table for liquid A as below.…
-
Copy Module Error & Solution
Hi all - I was having an issue earlier where I couldn't copy a module within one of my models. If you run into this error: “errorReference=“31511bca7bd64524b7108708bbc4a4fe-F26683FC11B149F68977313931A4D29B” userId=“8a819488469c08790146a6bfa7454c75" workspaceId=“8a81b0945db427df015dc7abfba910db”…
-
How to filter modules by custom made user roles?
Contextual explanation: Lot’s of Modules we use in our app are categorized by a List called Workgroup (e.g. modules for Suggestions, Decisions, actions…). Workgroup is a property in those modules. We want to limit what a user gets to see in those modules via user roles. One user role corresponds to with one Workgroup. But…
-
auto fill in User created in a line item
Hi, Situation: I have module with a list in the rows and line items in the columns. One line item of this module is called 'User created', the user who created the list item is supposed to be filled in there. I published the module to a dasboard. Question: Upon creation of a new list item for this module, is it possible to…