Modeling

How to create tree style
Hi! I want to show tree style like under one on the columns about List. I tried but tree view disappeared like above when I changed from raw to columns. Is it possible to show tree on the columns?
Planning,Budgeting & Forecasting for insurance
Hi Team, Please can anyone clear my doubt regarding group level in insurance app and what is the work done by the group level finance manager.What covers under the group? Is it region or something else? The below is the link for the app.…
Deployment of a Module view change
Hi experts, My colleague is encountering an issue. There are dev environment and testing environment, and he changed view of model and save it in the dev environment. Then, he tried to generate a new revision tag, but change in view of a model was not treated as "new revision tag". I mean, no revision tag was made. I'll be…
Create export with all Saved Views in Model
It would be really useful if there was a way to export all Saved Views present in a model - currently, they can be viewed in the Contents Panel on the left side of the Anaplan window, but text can not be copied from that section. There is also the Contents area of the Model Settings that is able to be copied and has an…
Trigonometry function app
Hi Team, Please can anyone explain in what scenarios trigonometry function app is used in anaplan.
Numbered Lists
Hi, I have a numbered list, in which i want the numbers to start from 1. I have used this list as dimension also have referred in some formulas. i entered wrong numbers when i was inserting numbers to the list. Now when i enter the numbers it starts from the next index number. is there any way i cant reset it? Thank You
conditional formatting based on text value
Hi All, I have a text formatted line item which gives me the text message "Error" or "No error" based on condition satisfied. I want to color all the row having message "Error" as light yellow and "No Error" as light green. Regards Madhu
Time Summary
Hi, I need to have a SUM summary for a line item but it doesn't add up but results to zero instead. I attached a screenshot for reference. Thank you.
Default selection in dependent dropdown selection
Hi All, Do we have an option to set default value based on the dependent dropdown list selection. I have 2 lists A and B. List B is filtered based on selection from List A. I would like to know if there is a way to select display default value after a value is selected from List A dropdown. Thanks, Aparv
Need Help on Filtering Data
I have a module containing multiple line items. One of the line item is "org code" with format "Text". I need to filter data based on the values in this line item. "Org code" is actually representing organizations under a department. One department can have multiple org codes. As an example, I am attaching a screen print…
New member or parent change flag
Hi, I have Account List, when my target list is updated with new member can it be highlighted in Dashboard. And Also when change in parent of the member can it be highlight. Please let me know Thanks Asha
Move User's Model Access into a separate boolean
It would be very helpful to have user role and user access to a model to be separately managed values. In some instances, we use ALM to move a big group of changes into our production model so we will remove access for non-admin users and reinstate them later. Instead of changing each of our 700 users roles to "No Access"…
Alphabetize a selection of Actions in the Actions List (Modules, dashboards too!)
I'd like to be able to select a bunch of actions in a list, and alphabetize just those actions. Currently you can alphabetize the list of actions but it only does the entire list. Our model has many actions (just shy of 2 thousand)...some of these are specifically grouped together by function, or by dashboard they're on…
Avoiding circular references with calculations on Previous List Item (Numbered List)
Hello community members! I am facing an issue which i cannot seem to find a solution to, but that someone might be able to help! This particular exercise started as a way to deal with massive amounts of sparsity in a model used by my employer. The business has a dimension (monthly vintages) representing monthly loan…
Save user roles globally across models
I have a couple of common user types that I always create for every module. It would be useful if these could be saved as default choices and used across all models in the workspace.
Moving line item subset to another module
Hello everybody! Currently I have really bulky module that is not used in any dashboard and line items are not referenced by any other module. I'd like to delete it though I couldn't due to the fact that there's a line item subset created using line items of this 'obsolete' module. I would be glad if you could share the…
Return Summary Value/Parent Value
Hi Team, I'm trying to create a function whereby I can return the parent value of a list item without using SELECT. I am trying to use LOOKUP & it is not working I have a source module with a list (Machines - with a top level of Total Machines), a Mapping module with the Machines list and a line item returning the PARENT…
Flagging Non zero , number formatted line item
Hi All, I have a number formatted line item, i want to flag this field in another text formatted line item. saying its " error in value" else " No error", based on blank or non blank of first line item. Regards Madhu
Is it possible to have 2 different formula on the same line item?
I am creating a module that needs 2 different formula on a bunch of line item. Basically, if it's Actual, than its formula 1, if it's Forecast than it's formula 2. Is that possible, or am I better of creating 2 different module and using dashboard to create this? I know i can confine the formula to Actual or Forecast in…
Subtracting Months when using lookup
Hello.. I'm trying to figure out how to write a lookup formula that will subtract months. For example, I have the following line items Hire Date (Month format) Set for Jun 19 Revenue (Number format) Has 100 for Jan and each month increases by 100 (so 200 for Feb, 300 for Mar, etc) Test Result (Number Format) In Test…
Increase in more than 1 million times for Breakback line items
Proposal : Increase in more than 1 million times for Break-back line items Benefits : perform large inputs in break-back for initially very small, but non-zero values, excluding the step of force zeroing values by each cell before break-back.
Add to Line Item Subset Items from different modules with the same Name
Being an Anaplan builder, I would like to pick line items with same name, but from different modules into one Line Item Subset. The behavior of items in LI SS in that way will be like in numbered list. Benefits: preparing reports, combined across big number of similar metric without creating and fake Line Item SS and…
To display a Text message in the dash board based on the Variance
Hi, To display a Text message in the dash board (Separate Grid not part of the line item) based on the Variance (If it is 0 to display message like " No Difference", If it is 1 " Need to take corrective action" ) Kindly Suggest on the same. Thanks Usha
Returning Parent/Summary value
Hi team, I'm attempting to create a function whereby it will return the line item value of it's parent without using SELECT. I have a target module with Machines List (Top level All Machines), a source module with Machines list and a system module with the Machines list & a line item returning the Parent of that list item…
how to avoid parents in a composite subset list
There are 4 levels in one list. A subset list is created where in subset is for level 4, but while selecting level 4 automatically the parents of all levels are selected and are visible to user for selection. I need a list selection in a module with the above composite list with format of a subset which is part of a level…
How to highlight with color entire row in module based on the Boolean check is True
Hi, Could you please suggest the solution on below. We have a requirement to highlight the entire row with color in module based on the Boolean check (i.e if it is True then highlight with color. Thanks Usha
If date falls within a date range in a list, then apply the end date of the date from the list
Hi, I have the following: • Module with a column for Lease Ending Date - My particular date I'm using for this example is 7/14/19 • List built that houses bi-weekly ending dates the Lease Ending Date can fall into (Goes from 2/3/19 to 2/17/19 to 3/3/19, etc.) - The date range the Lease Ending Date falls into is 7/8/19 -…
Date Format Conversion Formula
Hi, I am trying to convert a date from Ex., May 5 2019 12:00AM TO M/DD/YYYY format. I have created a list for all 12 months to convert May to a 5 by referencing the Code column in the list of months I made. I now need to pull in the day and year and add the slashes. Can someone please help me with the formula build to pull…
Clearing anaplan data before new load
Hi all, I have a module with data value against every month, and my process takes care of loading the new file data to the module. before loading new data file, I want to have a action to cleanup the existing data and the load the file data. Dont want to delete the target list here, but only the data in the module.…
What is Branch?
Can someone explain in a simple language of what is a Branch?

Modeling

Discussion List