Modeling

Rolling Sum based on Target days/weeks
Hi, I may be overlooking the obvious, but in the sanpshot below the blue figure is the sum of Demand for 3 weeks (21 days indicated by the Target Stock days) Is there a way i can formulate this? So it Totals the demand based on the number of days in Target (i understand that i may have to use integer(21/7) instead of…
How to show the data directly rather than drill-down?
Hello, Background: I have a numbered list with a property NLIST Name: Genera_Special PersonType <<Property Name John Doe General Bill Gates Special Joe Neighbor General Steve Jobs Special There is another numbered list NLIST Name: Rich_Poor RichOrPoor John Doe Poor Bill Gates Rich Joe Neighbor Poor Steve Jobs Rich What I…
Need to use annual amount in a formula but comparing it to a monthly amount in same module?
I have a requirement to show the following: annual quota * multiplier = target then compare month orders to this target and see if the person exceeded the target. I have a module at a monthly level, and if you go down to the Quarter or monthly level, the quota keeps changing, i need this amount to remain static, and let…
Adding a new column... WHY do i have to SHOW all of them and HIDE again
Hi No idea where the 'suggestions' forum has gone too, so will try posting this here. I have a module with 48 columns, and i have a dashboard where 24 of these columns are visible in a user requested sequence, if i add 1 new column to the module and want to see it on a dahsboard, i have to show ALL 48 columns then remember…
Request for SUMProduct function
Currently only when you use Time you will be able to use PREVIOUS() or alike function. These functions doesn't apply to Lists but at CBRE I have a case where do need a similar function. Today the SUM function, which doesn't allow for Product, therefor my enhancement request to create a function alike Excel function…
Level mismatch on common dimension
When trying to change applies to in the model - I get the error "Level mismatch on common dimension" - essentially switching out a list for another.
Countifs Function
Hello, I've researched this topic but haven't been able to find a clear answer. I'm looking to create a headcount dashboard that tracks historical headcount by function over time (by month). It looks as though I'll need to combine an "IF THEN" and a "SUM" function. I am referencing a module that has: Employee Department…
Poll: Is Anaplan your system of record for plans?
Just wanted to poll the community here - is Anaplan the system of record for your finance/sales plans? Or, do you expect the data you input to be transient and not persisted? (Not asking about transactional data coming from other systems.) Thanks!
Unable to import data for numbered list
Hi, In my model, I have an employee list which has been created as a numbered list with combination of properties (Emp ID & Cost Centre) to identify uniq. Now i have create Employee Cost module to which i need to upload the actuals number. In my source file i have Emp ID & Cost center codes. Can someone suggest me which…
Let end users add Clickable links
Hi Everyone, I'm looking for a way to let end users add documentation complementairy to their input into the model by adding a link to an external document. I created a lineitem (format text/link) in which they can add the link to their documentation. When they click the cell in which the link is posted, the link won't…
Importing data into months within a weekly timescale to breakback
I have data in a module with a monthly timescale that I want to import into a module with a weekly timescale so that it breaks back evenly across the number of weeks in that period but I can't seem to be able to do that via a data import. Is it possible? Likewise - if I wanted to upload from a CSV containing monthly data…
Retrieving YTD value when timescale spans multiple years
Hello, I am having trouble with how to model for multiple time period aggregation combinations. Using units as an example, I want the units for the individual time periods, quarters, and years, however I also require the QTD, YTD, and YTG (Year to go). What is the best practice to incorporate this into a module? I…
Referencing Line Items from Other Modules/Lists (Performance Questions)
Is anyone able to describe the performance impact (if any) of referencing line items from other modules or lists which have the same relevant dimensionality? Particularly using SUM and LOOKUP operators. For example, a model may have a Register A and a Schedule B (over time), both of which have the same dimensionality…
Date Conversion
I have a line item that contains the date in a Text Format(examples below). Is there a formula that can convert these numbers to a Month Format? 2018001 2018002 2018003 2018004 2018005 2018006 2018007 2018008 2018009 2018010 2018011 2018012
Actual vs Last Year
I would like to store last year actual value in version. So my version willl have Actual, Last Year and Act vs LY Variance. Can I achive it using formula in Version setting? Thanks and regards, Maung Maung
Show hidden content
Hi, Is there a way to disable "Show Hidden Content" at the bottom of the content list? I want my users to be able to view the dashboards only wihtout viewing the modules.
How to use the SUM function
Summary: When building Anaplan models, the SUM function is used to add up values that meet one or more specific criteria. Find out how to construct a formula using the SUM function in this short lesson. Course Objectives: By the end of this lesson, you’ll be able to: * Identify source and mapping cross reference data to…
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…

Modeling

Discussion List