-
How should I debug to see what's happening exactly in my formulas?
Hello, One of my client is operating some models which drives a connect Supply Chain Network, and they need a stepwise debug execution so as to see what's happening exactly in the formulas. Due to the fact that most of formulas are bid over complicated, step by step debug execution would be nessary. Any ideas and comments…
-
Calculating the IRR for a subset of cashflow
Is it possible to use the IRR function to calculate only a subset of the cashflow? For example, in Jul 18 I'm looking to calculate the IRR of the cashflow from the beginning to Jul 18 and then on Aug 18 it will be from the beginning to Aug 18. In excel you can simply have the formula as IRR($H2:I2) and apply that across…
-
Dropdown (Time dependent)
Hi community, we currently working on a anaplan project and can't fix one major "Dropdown/Selection" problem. Background: It's for a HR Planning Tool So we have our module "position planning" where Employees were assigned to a position. Therfore we just made a Drop Down, where we can assign them. But now there comes the…
-
Creating a formula to directly change a User's "Model Role" as well as read/write permissions
I have created and set up Model Roles, Selective Access, Content Access, Permissions and a defining value applied on the lowest level of the list heirarchy for what I would like security permissions to be. I have 4 levels of security with the highest being Full Access, and the lowest being No Access. The inbetween levels…
-
Need help in Formula
Hi, guys! I'm doing a logical formula in my module that says if a Unit (Line Item) is classified as Current (List: Sales Type) then it will perform a certain calculation otherwise if it is Non Current (List: Sales Type) then it will display zero. Can you please recommend me a formula for this? Note: I have uploaded the…
-
Align Dashboard Columns
Attempting to publish 2 views to a Dashboard but just different versions so to be able to visually compare the 2. I hid the Department List column on Published view 2 so you would only see: Department, Column 1 results (Version 1), Column 2 results (version 2) The issue that occurs is the column 2 results will not align…
-
Unavailable Action Help
Hi I have a Button/Action on a dashboard showing unavailable, and if i look in contents i can not tick it, then comes the fun of trying to find which action, module, dashboard etc etc is the cause. I have been looking for an hour now and still no joy, is there a way this 'unavailable' could be more useful?
-
How many modules should be in one Model general?
Hi I'm planing to re-factoring our client's Models as some Models have over 100 modules which is not easy to maintain. Please advise how many modules should be in one Model in general. Best, Hisashi Yamaguchi
-
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?
-
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.