-
Monte Carlo Simulations
Dear Anaplanners, I would like to know if Monte Carlo Simulations are possible on the Anaplan platform ? I would appreciate to any kind of help pertaining to this topic. Thanks a lot. regards, Krishna Veera
-
field missing
. I have two modules with the same dimensions. I’m bring fields into the calculation module from the import module. I’m bring fields into the calculation module from the import module. This works fine for tons but not for percentage distribution. I created a test field and change time scale to year and the values show up…
-
Time Scale changes
Hello, Please do let me know if there a way to rename the Time period Label of Year? For eg FY2015, FY2016 etc. to 2015 or CY2015. Thanks, Suneesh
-
'Formula' sum for 'list'-formatted line item
Hi all, This article ( https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Summary_Methods.html ) claims that list formatted line items can have 'formula' as summary type. In reality it does not work for me. If I try to set summary type to formula - system tells me to enter formula first. I do that and try…
-
Lookup between list formatted line item value in one module and list property in another module
Hi All, This is around a Top-Down allocation functionality being built for Demand adjustment. Based on the available capacity & resources the demand needs to be adjusted but instead of adjusting at the lowest level (Devices) the idea is to adjustment at another higher level(Packages) and the % adjustment flown down to the…
-
Compounding across a list
Hi. I've a question as to how values can be compounded across a list. i.e. If I was to have a 'Driver list' of 3 items. Each driver item improves sales by 10%, the total improvement to sales is 1.1*1.1*1.1=1.331 or 33.1%. It is similar to how a product fucntion would work in Execl. Checking the Anaplan v Excel…
-
Top Level on the Users List?
Hello, Is there any way to get around not having a top level on the users list, other than creating a "fake" users list with selective access?
-
PREVIOUSVERSION(Data) not showing prior forecast actual data - please help!
Anaplanners - I am using PREVIOUSVERSION(Data) to pull the previous forecast's data (formula in first pic). It's not pulling actuals before the current month I.t seems to be working fine prospectively for future months and pulling in the previous forecast's values for future months. I tried the following formula but to no…
-
How to write an IF function so the boolean applies to more than one month
I am writing an IF Function (IF START()>CURRENTPERIOD() THEN TRUE ELSE FALSE) the result will be a Boolean. How do I make it apply to the next 6 Months or PERIODS? Thank you
-
Can not import with Anaplan Connect
I've tried to install the Anaplan Connect following the video tutorial, but every time I end up with the following message: INFO: I/O exception (java.net.SocketException) caught when connecting to {s}->https://api.anaplan.com:443: Connection reset Then after the batch file has retried several times and failed, I get this…
-
PREVIOUS() for line items in a module not involving time dimension
I am working on a module in which have two related line items (L1 & L2)& a dimension "Period." For Period A is L2=0, Period B L2 = Period A L1 and so on. I am trying to figure out a calculation for the Non-time series module. Example of module given below: Period A/Period B/Period C/Period D/Period E L1 13/15/16/18/19 L2…
-
How to create allocation key based on last forecast data
Hi, I want to create allocation key which allocates an annual budget data to each month based on last forecast data. Budget and Forecast are two separate version (of course) in my module but I can not find a way to calculate it. thank for your help Jérôme.
-
Dynamic line item
Hi Team I have a line item Existing Product formated as a List of Products. The value is being picked from another module. I am creating a new line item New Product again formated as a List of Products. I need to have this list as a dynamic list where the value from the Existing Products is removed. Since Product lists is…
-
Multiple hierarchies sharing same children
Is there a way that you can assign multiple parents for a list member? Or when you need to build an alternate hierarchy sharing the same children of primary hierarchy, you have to create a new 'child-list'? Thanks.
-
A way to only see lowest level in dependent dropdowns?
When using dependent dropdowns, is there a way to make the module only show the lowest levels? Currenly the lowest levels are the only selectable options, but it still shows you the hiararchy above that - just greyed out - which can look a bit untidy when trying to make a simple dashboard for an end user. Thanks.
-
Timeline Charts
Hi Please can somebody throw some light on timeline charts? Anapedia offers this....... "Ensure the data items are date-formatted line items displayed across columns." This seems a little vague, does anybody have an example or some guidleines please, as i have a project model and would like to show a timeline chart (as a…
-
converting a list of postal codes into postal code ranges
Hi, I am trying to write an array formula in Anaplan which converts a list of postal codes into postal code ranges. He is the link for an Excel equivalent formulas. https://www.mrexcel.com/forum/excel-questions/411304-creating-zip-code-ranges-one-list-help.html Can anybody please help me to write this formula in Anaplan.
-
Creation of General list for user data entry
Hi All I am trying to do some simple setup in Anaplan and need your help.I am trying to create a general list with few columns where user will enter data. We dont need any hierarchy here and we are trying to mimic the attached excel sheet format in this proposed Anaplan list. The idea is user will maintain the data in this…
-
Guru hours?
I'm working on simplifying our model and introducing pretty straightforward Forecasting capabilities to the deployment. I've heard that we have access to guru hours. What are guru hours?
-
Versions page selector for only the Prior Forecast column
Anaplanners: does someone what formulas would allow me to reference another forecast for the Prior Forecast column? I want to compare the most Current Forecast against whatever forecast the user chooses (April, May, etc). Would appreciate any guidance and thanks as usual.
-
Formula to calc workspace size
I am trying to determine the workspace size I will need for my organization. Is there any formula to calculate that (e.g. # cells x bit/byte or some other way to calculate)?
-
Module to Module Import triples source values
Hi, Anaplaners, I have faced an issue where module-to-module import triples values of a source module. I am trying imporitng between modules whose structures (lists in row/column) are exactly the same (only line items differ), but for some reasons, values triple everytime execute an import between the modules. Do you have…
-
Collect Function doesn't work
Hi, guys! Collect function doesn't seem to work on the model that I am currently building. I have created line item subset using one of the modules I have created. I used this line item subset in my current module which has the same dimensions as with the source module where the subset comes from. I can't figure out why is…
-
Selective access list to generate a date when changed
Hi, I have a slective access list for approving a transaction, where certain people can approve a process or reject, challenge it. When they choose 'approval status'.approved', i would like to add the date to a line item. Adding a date to a line item is easy enough, HOWEVER the date field cannot be open, or people who do…
-
RANK with Selective Access
I'm trying to build a module that displays only the top ten cost centers based on a variance line item that I've got calculating. I'd gotten it to work with a RANK formula and then a boolean line item, but then when I started trying it with selective access set up on the cost center, it broke and I only see a few of what…
-
How to find Delta value between current period record and most recent period records.
Hello All, Need you help in calculating the credit for sales rep month by month for Orders he is working on. Order#Order StatusInitial Order DateOrder Change DateNet ValueDeltaPayout 111Initial Order01-Jan-18 100100100Jan Credit111Changed 01-Feb-18150150-10050Feb Credit111Changed 01-Apr-18300300-150150April Credit…
-
Collect Function doesn't work
Hi, guys! Collect function doesn't seem to work on the model that I am currently building. I have created line item subset using one of the modules I have created. I used this line item subset in my current module which has the same dimensions as with the source module where the subset comes from. I can't figure out why is…
-
How can you capture the last update date in a list?
Hi I have a requitmemtn where the data is maintained in a List and when the user updates the data (edit/create),then we should capture the system date in a column in the list. This is to know when the data was last updated. Appreciate any pointer on how this can be acheived . Thanks Regards rabakaran
-
Collect Function doesn't work
Hi, guys! Collect function doesn't seem to work on the model that I am currently building. I have created line item subset using one of the modules I have created. I used this line item subset in my current module which has the same dimensions as with the source module where the subset comes from. I can't figure out why is…
-
Naming Convention : tips
Hi, anyone should read an apply the Naming conventions which are described in Anapedia. I found it usefull to add some personnal ideas. When you build a model, you will often find duplicate names for : * module (Sales Plan) * dashboard (Sales Plan) * action open dashboard (Sales plan) Of course Anaplan will prevent using…