-
how to apply top 10 filter
Hi, We have list that has around 4000 clients. In the module we have uploaded Revenue of the clients. We have sorted out the list in descending order based on Revenue. Now we need to apply filter to show only top 10 clients. I tried using filter option. I couldnt get the data. Can someone suggest please. Thanks, Sangeetha
-
Eliminating 0 cells without subsets
Hi, Is there a way to eliminate the cells with 0 from Module in order to reduce the space consuming. I have already gone through 310 - Elilminating Sparcity course, in which recommandation is to create subset for the list & eliminate unnecessary verions or lists used. But in my case i can't create subsets as it is a list…
-
last modified by
Hi , Greetings ! . Is there a way to find out which user did the last modification in a Anaplan model ?.. Thanks , Praveen
-
Automatic access authorization
Hi, If selective access is applied to a numbered list, when a end user adds a new item to the list using Create action from a dashboard, is it possible that read or write access is automatically given to the user or all users? Thanks and regards, Maki Yasuda
-
Create lists with Code in text format
Hi, I have list called "Employee" with code like "0000007". I need to import this employee details to my list. But when i convert my input file from excel to CSV, the code column getting convereted as number (like only '7'). Can someone help me to create the list with text formatted code. Thanks, Sangeetha
-
Using a dimension in a line item
I want to vary a (volume)number based on a chosen selection. Easier to understand with the background. I am working on a module in nuclear environment. Istopes decay ( in this case Mo-99 decays 0,7767 per day ). We use several standards ( Activity Reference Date ) to refer to the activity at a certain point in time. The…
-
How to get next item in list of Numbers?
Hello. There is a list of numbers (not number list) - 1,2,3 etc. There are no other dimensions except this list of numbers. No Time dimension. There are 2 line item: Lead Column and Cost Centres Could I put Cost centers to every row, like in a picture below? Thanks for Help.
-
How to display concat eliment of a list in different order
I have a list with values in the format "<description>-<code>" (seperated by -). I am displaying that list in one column of a module as a drop down from where user can select. I need to change this format of each value in the list like this "<code>-<description>". Can I do this using some formula over this perticular…
-
How to convert monthly exchange rates into daily time scale
Dear colleagues, I have daily cash flows forecast in foreign currency (for treasury purposes) and monthly exchange rates forecast. An only I need for daily cash flows forecast in local currency is: convert monthly exchange rates into daily time scale, but it looks to be sophisticated formula. Thank you in advance for any…
-
App for daily production planning
Hi, is there somewhere an app where i can see daily (production) planning at work. I need some entry dashboard with days ( as part of the time dimension ) and would like to see a good practice example instead of building it myself. Or screen shots of a model you have access to will do to ( blueprint and grid views , please…
-
Boomi RESTful API to Anaplan using certificate
The Anaplan connector in Boomi is currently in it's 1st version. It currently does not allow Anaplan users to a certificate to connect with, instead forcing the use of IDs/PSWDs, which means that every 60-90 days the password will need to be changed. There is hope! - - - - Using Boomi's generic HTTP connector to access…
-
Boomi RESTful API to Anaplan using certificate
The Anaplan connector in Boomi is currently in it's 1st version. It currently does not allow Anaplan users to a certificate to connect with, instead forcing the use of IDs/PSWDs, which means that every 60-90 days the password will need to be changed. There is hope! - - - - Using Boomi's generic HTTP connector to access…
-
Post a list total to a list member
I have a list total ( with several individual members) that i want to post/copy to one list member of another list in my module. standard sum nor lookup nor select do the job. Business context : the list where i want to copy from is a list of opportunity sales ( and can vary in time). The sume of these opps is a…
-
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…
-
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