-
TEXTLIST as aggregation function, but only display unique
Hello, Is there a way to get the TEXTLIST function, when used in the aggregation format, to only display unique entries? I have the formula working in my model, but it is displaying every entry under the parent, rather than unique entries. I know that the normal TEXTLIST function has a "UNIQUE" option. Best, Matthew
-
Save Subsidiary view as default
Hi When I click on the eyeball to open a subsidiary view, I get the default grid format with Time in columns. I can pivot the grid as desired, but then, how do I save this as the default view so that it opens like this when I click on the eyeball next time? I can use 'save as', the view is saved as a subsidiary view and…
-
Mailto function multiple line body
in regard to the mailto anapedia, how to have the body of the email to have multiple lines? i.e. how to make %0D%0A work in to the mailto formula?
-
Suggestions on how to optimize data imports for a Real Estate Company with many products
Our company is a real estate developer and I am having a problem dealing with too much data. For example, we consider our condominium units as our products. These units are unique from each other (i.e. they have different unit number for each building and for each project development.) In short, no two units are the same…
-
Dynamic Versions in Anaplan
Hi Team, My model has 4 versions: Actual Version: Monthly Input Forecast Version: Once yearly Input Q2 forecast Adjustment: Q3 Forecast Adjustment: Let's suppose we have forecasted for whoel year and users are done with Actuals input of Jan,Feb,Mar,Now the Higher management wants to adjust there forecast for Q2 in which Q2…
-
Mapping between dimensions at minimal cost
I want to pull data from line item, M1.LI1, into another M2.LI2. The 1st line item is dimensioned by standard list SL1 and numbered list NL1, the 2nd is dimensioned by SL2 and SL3. NL1 has a property formatted by SL2 whilst numbered list NL2 maps SL1 to SL3 (SL1 are financial weeks and SL3 are calendar months – some…
-
Problem with specific tenure?
I am looking for the best solution how calculate/distribute an amount within specific tenure once it was triggered by a variable. Example: 1 million of revenue will be recognized equally over 24 months once the project is completed. The 1st month of the recognition starts on the following month once the project completed…
-
Syntax for a variable Line Item in a formula
Hi I'm building a module where I want to pull values from a subsidiary model, but the line item I want to pull from varies according to the member of a particular dimension. For example, if I'm looking at dimension member "APPLES", I want to get my data from the line item "line_item_a", but if I'm looking at the dimension…
-
Find the common parent of two list members
I have an Entity list which contains the entities in my organisation. If, as the result of another calculation, I have been returned two entities in the Entity list, how do I determine their lowest common parent? Some combination of PARENT and FINDITEM seems likely... but they might be at different levels.
-
How do I sort a list?
In excel, order the list members (members only, not parents, etc, just the members as they appear in the list in Anaplan) in the order you would like it in Anaplan. Then copy just the list members. In Settings->List->Grid View (not Tree view!) of the list, click Insert, choose Start as the ‘position’, paste in the list,…
-
Count the number of sparse cells in the MODEL
Hi There, Can anyone lemme know if we can count the number of sparse cells in our Model? Basically, we want to know the number of blank/non-zero cells in a model (Or) can we count the number of cells which has data in it? ( as per my understanding, if we get the sparse/non-sparse cells we can subtract this from the Total…
-
Line Item (List) link into a module
Hi everyone, i have a module with several line items. One line item is a List, another one is a number. After i have selected a value and entered a number, i want to link the value into a module which has the List as in the rows. Any idea how to link the data ? I would like to have the value number entered only appear on…
-
Restrict Access of Line Items to Supplier
Hi, I have a dashboard, containing a module, with approx 20 columns of data, dates and text. We are sharing this dashboard with a supplier who have their own user, and role setup. In the dashboard, there are 6 fields that are updateable by users within the business The supplier needs to be able to see ALL the fields, BUT…
-
Synchronizing dashboard scroll bars
Anaplanners: I am thankfully almost done with my dashboard which is essentially composed of the same modules but I need have the up & down scroll bars synchronized; I tried to sync the rows but that simply collapsed the modules. Is there an effective way to synchronize the rows so that the user will have the same rows at…
-
Adjusting Long Formulas Tip
Since trying to follow long conditional formulas can be tricky within the Anaplan formula bar, a tip to make it easier is to use the Drilldown capability on a cell within the line item. By doing this, you're able to see the If Statement/Formula indented with each If Statement. After seeing it in Drilldown, you're able to…
-
Level Mismatch on Common Dimension
Hi All, I have a data entry module with 3 lists: versions, row id, and line item list. I have 3 line items: person, cost center, country, with type of List and link to person (L3), cost center (L2), country (L1) lists. The input is to select person, then cost center and country is derived from the hieararchy. The second…
-
Versions to compare latest plans
I want to be able to compare to earlier versions of the plan ( so when we can to month +1 i want to be able to compare ‘current’ plan to previous plan ( and also with earlier versions). There is a solution in creating a seperate version and then bulk copying into it. Is there a more automated , best practice or simple…
-
Holding a Breakback on two different module views
Hi all, I have, in a Dashboard, two tables form two different views of a single module. Those tables allow to change data in it and both are linked to the source module. The first table displays by country (with product as a fliter) and the second one displays data by product (with country as a filter). I have a breakback…
-
Numbered Lists renumbering
Hi, The number of IDs on the numbered list is 999,999,999 (based on information in topic related with numbered lists)- what about reaching this limit. Is there any list renumbering possibility?
-
Multiple Selection of List items and their total
Hi, Anaplaners I have faced an issue where I am not able to select multiple list items (in the attached excel, Product A and Prodcut B) to show what is selected and their totals. What I came up with is when products in the row do not equal to Selctor 1 or Selector 2, set 0 and hide 0s. But the problem is this idea would…
-
creating a discount table
Hi There I am trying to drive a different profit margin based on volume (by client). Simplistically, I want my margin to be 20% for a volume of 1-5, 19% for a volume of 5-10, 18%: 10-15 etc.... I am sure this is simple but I just cant make it work Anyone got any advice, please?
-
How and Where can I use data tags.
Hi, I am trying to understand how to use data tags , I uderstand that we create tags in settings and assign the same to various objects in the model however I am not sure how and where can I use those tags.
-
Access denied to 299 Project
Hello, I have tried to get access to the 299 Case Study. But, the access is denied. Can you please help me found out where the problem is. In fact, I already passed all the courses and certifications required for this step. My username is NFWADE. Thank you for your help.
-
Anchoring Certain Months Data Forward Using Boolean
Hello All - i am trying to forecast out data using actuals. I want to take the weighted average of the last three months of actual data (green box below) weighted by net auctionable (purple box below) and forecast out the rest of the year using this average. I setup a boolean row (red box below) in order to indicate which…
-
Parallel hierarchy
Hi All, Can anyone please let me know how to create parallel hierarchy in lists? I am working on a problem and as a part of the same I need to display same data in 2 different hierarchies. Thanks
-
Switching calculation based on a property or a code
Hi I want to set up a module that contains a set of scenarios. The idea is that the module would contain various iterations of a set of base data, and that the calculations happening in the module could be switched to use a different scenario's data. I'd like to make that switch happen without having to change the…
-
Generalised currency conversion
Hi I'm building a model which holds revenue data. The revenue that the company receives is in a mix of US Dollars, UK Sterling and Euros, so one of my lists represents currency. There is a requirement as well to aggregate that revenue into a single "Converted Sterling" currency, which would be calculated as (Revenue in…
-
RANK function ONLY returns 1 when ranking in Anaplan Time dimension. Bug or intentional?
Hi Forum, I am new to Anaplan, this is my first post ... Set up to Demo problem: * 2 dimensdional module* Anaplan Time dimension in columms; * 2 line items in rows;* 1. Some numbers to be ranked * 2. RANK function ranking Line Item 1 Problem: RANK only returns rank 1 for all the numbers ranks, even though they are…
-
201 Intermediate Model Building Section 8 actvity #10 Numbers don't match
I'm working on Section 8 of IMB and the numbers in the sub-region Goal set don't match for US South and US Central. The totals in the bottom row do match with the guide and instruction video, but these specific sub-regions don't. PY Sales and Sub-region % are correct, but the Projected Goal is not. All other sub-regions…
-
Page Selectors - Isolated
Hi We have a module that has 'Customer product group' as a page slector. and then many line items. On the dashboards (3) we place the Customer Product Group' list, to allow the user to choose a customer and then synchronize the output. However, when we select CUSTOMER A on one dashboard, the other 2 dashboards also change…