I am trying to get the underlying number from a numbered list for referrence on imports; without turning display name off and on. Is it possible to create property in a numbered list to return the und…
It would be very useful to add a simple tickbox to choose whether to show or hide a row or column. If often find it useful to hide as much as possible when searching for bugs, going thru row by row wo…
I'm trying to find a "day of week" function. Essentially i don't want to count hours on the weekend. Any ideas? It seems like it should just be a formula dayofweek(start()) but i can't find anything l…
In several cases I need to use a subtotal for 5 quarters in calculations. I have been using the All Periods total for most and it works some of the time. However, often I don't want values included fr…
Hello, When we built a model recently it was all setup with Quarterly data. Now the business is going to change to monthly data. So I need to change my module to include the months. When I do this I s…
Dear Anaplanners: I have a question regarding usage of IF conditional statement. All the conditional constructs in Anaplan are related to IF with ELSE as a mandatory clause. However, I have following …
I have some data as per below table. RevenueCountryNew bizJanFebRev aChinaY 3,000.00 3,000.00Rev bHong KongN 2,000.00 3,000.00Rev cChinaN 4,000.00 5,000.00Rev dHong KongN 2,000.00 4,000.00 I would lik…
Hi, I have a list of deals which are imports from salesforce opportunities which I need two things done to. Firstly i need them sorted by the close date and secondly i need a cumulative sum down the l…
Anaplan's equivalent of a COUNTIF function While Anaplan doesn't have an official COUNTIF function like Excel, you can combine an "IF THEN" statement with a "SUM" function to accomplish the same goals…
Hi Expert, Currently we are implementing ANAPLAN solution , and we have questions and would like to check with you. 1.Is there any functionality in ANAPLAN similar to "FREEZE PANES" in EXCEL to lock t…
Hi, I am trying to create a module that contains line items for Gross Cumulative Project Valuations. I need to be able to calculate the individual valuation (the current cumulative less previous cumul…
Hi, I am working on a retail POC which is based on daily sales. The modules I've created contain a Day timescale which works fine. However, I don't seem to be able to create a Time Period Format that …
Hi, Is it possible to publish an Export action to dashboard? When I put the cursor on the specific export action the view menu is not available. When I stand on an import action the view menu is avail…
Hello Anaplaners: I have a following questions - 1. Is there any way that lets me change the properties of a cell based on certain values? For example, If flag in cell A is set then I want to make Cel…
Is there a way to add property value to non-leaf item in list? I think this requirement is meaningful, if not necessary. However, found it undoable in the grid view of list.
We have a client that will have users around the globe. As an example, if one user is in China, and is providing local data and local entity descriptions (eg accounts, departments, etc) in local chara…
Hi, I'm using Anaplan Connect to automate my data loading. In order to use my batches in an scheduler I need to output the return codes of Anaplan Connect (ie. file not found, the certificate has expi…
Hi everyone, I'm working on a Dashboard. The main goal of this dashboard is to compare differents scénarios (ie Versions). Users are supposed to be able to create and delete scenarios (ie Versions). I…
Hi all... I'm a modeling newbie hoping an experienced Anaplaner can spot my mistake here pretty quickly. I inherited a model containing Module XYZ that contains a line item with the following formula:…
Hi, I have a module with a few list-formatted line items. These decide how a nested line item in another module is calculated. I noted that changing some of these list-formatted line items causes the …
I am trying to implement a ranking function which based on user selection of filter on a hierarchy list provides top 5 records i.e if he chooses the lowest level in hierarchy he gets top 5 results on …
Does anybody has experience with linear regression in Anaplan? I also need to create a statistical model for detrending and deseasonalizing time series...any ideas? 🙂
Is there a way to map one module to another, mapping the intersections of two dimensions? a module with old locations in one dimension and old depts in another dimension mapped to a second module with…
Right now I can give permissions for Item in a list only for Specific user . is there a Possibility to give permissions for Item in a list for ROLE and not Specific user?
Hi, From time to time, it may be convenient to create an adhoc subset as an alternative for the SELECT Function. Business case : * Source module : full list * Target Module : need to select only one l…
Hi, I am fairly new to Anaplan and I have a requirement where there are 2 models with a common text line item . I need to create a 3rd model by comparing these 2 models based on the text line item to …
Hi guys! This is my challenge: I have build a Bakery model. I have 8 products, the products are devided over 2 categories. Of all the products I have the COGS, selling price, turnover, sales, total co…
I'm trying to build an exception module to check that all items in a particular list with a particular property residing in another module belongs to a subset in the list. Is there any function like I…
I want to show 2 types of conditional formatting for 1 line item, 1 for the children and 1 for the parent. Is this possible? Eg i have 10 questions scoring 1-5 (1 being red – 5 being green), with a to…
