Modeling

Project Planning v.1.2.3
Hoping to see if anyone has created a simple project plan . Task/Start/End/Owner/% complete in the Project Planning Model. When I start the process I get the below error. The list specified as the page selector is empty so there are no items to select. Ask your workspace administrator to add items to the list or remove it…
Defaulting values for line-items (vs. modeling via override)
Abilty to have by default a 100% value in a line-item vs. modeling this behaviour with a line item of 100 and putting an override if you do not want 100% (e.g. redemption rates). The default should be able to have a formula behind it. (cfr STET functiona in competitive products) Benefits : 1) Huge UX improvement on…
cell security change for model builder
Hi All, The cell security is a great feature, but I find it a bit confusing that as a model builder you are able to upload data where a normal contributor is not able to upload data. This makes it more difficult to test solutions, because the model will behave differently if you are a model builder versus when you are a…
Applies To for a module - would be nice to have a search option
Description of the enhancement required: Creating Modules or adjusting the "Applies To" it would be helpful to have a search bar/button. A story for why they want the enhancement, (how would it help their business process): In case you have a lot of lists, it becomes very inconvenient to reapply the module. This change…
Display the Action IDs in Actions list
Description of the enhancement required: Display the Action's IDs in Actions list so that Interface (Anaplan Connect or Rest API) can work with action's IDs (not with captions (Action Names)) A story for why they want the enhancement, (how would it help their business process): At the moment, to refer an action by ID we…
Increase the limit of characters in Notes section
HI Team, It would be really helpful, if we can increase the limit of characters in Notes section of a module. Currently it has 250 as a limit. I got stuck here when I tried to copy paste one lengthy formula cos I don't want delete the formula instead I might take that for my future reference. Let me know others thoughts on…
Weekvalue formula
Hello, I'm trying to pull weekly data into a module that is based on months. I've tried to use the WEEKVALUE formula, it returns 0. My source data has a week value assigned to it. Thanks Hina
Exclude Zeros From Average
I am calculating an average but I do not want the zero values to be included in the average. How can I exclude them?
Dynamic Display based on Time Period Type
Purpose: Retain views with multiple types of time scales/periods in the same view during YoY rollover, for multiple line items or list items, in a single view. Example: Dimensionality: Vertical/Columns- Time/ Line Item Horizontal/Rows- List Members Display: Line item 1 - Year only Line item 2 - Non-applicable (Display Full…
Disable endusers to change name of list items
Hello everyone, With several models up and running, we have encounterd the problem that some overenthusiastic collegues double or trippleclick the name of listitems that are presented on dashboards. This will allow them to change te name of the selected listitem. Is there any option to disable this function? The model…
Using Lists in IF formula
I'm trying to create a formula to say IF 'countries-filter'.'1' LOOKUP[Countries.'UK & ROI' ] THEN 'Actual (Current View)' - 'Forecast (Current View)' ELSE 'Actual (Current View)' - 'Forecast (Previous View)'. My countries are a list, so i created a Boolean module. 1 - UK 2 - IT 3 -DE I don't think i've set this…
Delta Load
Scenario: I changed the parent of a child then how to do incremental load when there is a change in parent child hierarchy?
Edit Dashboard
Dear Members, I am getting a Slider which I want to remove. Desired Format has no Slider. Please help me to remove the slider from Dashboard. Thanks.
Fp&A case study access (299)
Fp&A case study access 299Could you enable my access to FP&A Case Study please. I have completed courses 100, 101, and completed certification for 102, 201 Saurabh Sharma saurabhsharma08@hotmail.com saurabh.sharma@acgindia.co.in
Delta Load
How to do incremental load when there is change in any one of the list properties?
How do I get the data from a line item of a list in a module into another module?
I have two module. One call assumption, another. call Implied new room. I want to get the data from the line item call mix which is base on my subscription list from the assumption module . In my Implied new room module, I have 3 line item with the same name as my subscription list. I don't want to use a list because I…
Dashboard Header Module
Dear Members, Require your help in removing the Module Name from Dashboard. I have shared the Desired Format (How I want) and My Format (How I have). Please feel free to ask in any difficulty of understanding.
Create Child in Numbered List
I had the original Model, and I was trying to replicate it. The pic 01 and 02 are the Original ones. The pic 03, 04, 05, 06 are my Model. It is restricting me to enter the values:- Soft Drinks, Tea.... I even tried creating .txt file and import it but it failed too. I need your kind help for this. Please feel free to ask…
Text function; Automatical conversion to scientific notation
Hy everyone! I'm encountering a problem with converting my values to text with the TEXT() function. My problem: When the value is 10,000,000 and I use the text() function, there is no problem. The text line item will show "10.000.000". When the value is 10,000,000.15 (with 2 decimals <> 0), The text line item wil show…
Ability to sort the order of views on a module using Ascending or descending options
Currently when you click Manage Views on a Module you can move a view up or down to change its order. It would be easier if we could have the option to sort in the same way for other objects with an ascending and descending order option or a top or bottom option. In addition you can only move a view once in either an up or…
Import period format to Time Periods or Date formatted line items
As we drive to remove Text from our models, dealing with Dates is troublesome. When mapping files to Time Periods in modules, we can choose periods and define the format. For example, in my file I have YYYYMM. However, when I am trying to bring this data into a formatted list I do not have this choice. Even when formatting…
Cut line item list formant
Hi! I've got line item formatted as a list. This list has got a different level of summaries. Is there a way to cut somehow this dropdown list so the summaries wouldn't be included, ie there would be only items at the lowest level of the list? Thank you.
Summing Module Results at Different Levels in Hierarchy? Even when I exclude the parent.
This is in regards to the SUM on the bottom right corner when you highlight the total number. It varies from different Hierarchy level of my chart of account. I have a parent and child chart of account with a top level. Ex. COA. COA L1 Top level is Total GL When I click total GL only and not select the rest, it shows me…
Why won't my vendor roll up to my Total department. It seems to be only this vendor.
I created a a vendor call MISC. Its to group all the vendor under a certain amount to MISC rather than showing a bunch of vendor. When I select Total Department, MISC won't show up. But if I go to the specific department call N/A or No Department, which is the roll up level. It will show up. I tried moving N/A around to…
Sorting of list when used as line item
Hi, I need to change how list hierarchies are sorted when used as format for a line item. See image below; In this case, I have 2 lists, where the ones named "Parent" are L1-level and "Child" L2-level. As shown in the images, the child are above the parent. I want it to be the other way around. Does anyone know how to do…
Line Items Not at the Hierarchy of the Line Item Subset
I have inserted line items into a module where I have a line item subset set up. In the module where I am using the line item subset, the inserted line items do not fall in the hierarchy in the subset . thanks iosman
employee cost center change
Hi, I have set up employee list where in cost center is the parent. But how will the change of cost center be handled in Anaplan? If I just change the parent of the employee then the change is retroactive which should not be. Any suggestions? Thanks, Ana
COUNTA formula in Anaplan
Hi, I was wondering if there is in Anaplan the equivalent of the "COUNTIF" Excel formula: basically counting the cells in that range that match a specific condition. I was thinking of using it for calculating the % of Cost Centres that have input data so far against the one that have no values. Many thanks in advance! ****
System Default date
We are building dashboard with workflow, where user approve/reject demand plan, would like to keep system date so that we will know when user made changes. It would be great system default date and time can appear there. Thanks,
Simple yearly average
Hi All having completed the 102 course I am in the process of building my first model, so please be gentle if I have asked a ridiculious question but I really cant figure this out. I have a line item showing balances across time periods and I would like a second line that shows the average for the financial year for the…

Modeling

Discussion List