Modeling

Time Subsets
We would like the ability to create time subsets for more granular time ranges (days, weeks, months), that may not match the current model Time Scale of Years, Quarters, etc.
2.4.7 Activity: Create Saved Views for UX
I'm lost at conditional formatting to only show the highlighted items in the example. Is there another formula I should be using in a module or this same module? How do I get the conditional formatting box to allow me to select "SF Bay..."?
What I can do to make sure I get accepted to the Anaplan Model Building Course?
Hi everyone, I have registered for the Anaplan Model Building Course. How long before they contact me and inform me if my application is accepted? I really want to get this course and am eager to learn about it. Is there anything I can do to make sure I get accepted? Thank you, everyone!
Fake Time to Real Time Calculation
Dear All, I have one use case where I have created one template for input the data. For this I used fake time dimension because the data will enter at monthly level in Year 1 and for future it's on yearly. Screenshot one shows the template which used to enter. But I am stuck between creating summary report. Because for…
Multiplication and adding two different line items
Class 1 is starting from 7 mar and class 2 is from 21 mar Now i need to write formula in Total For example in 21 mar Column, 62 * 2 (which is week 3 * prod ) and 80 * 2 (which is Actual Start - Day 1 * Prod (Next Wave)) (62*2)+(80*2) = 284 ----- the formula in Total is not correct now I try averaging the Prod and Prod Next…
How to get a first value of line item
Hi, I have requirement where I need to identify the first value of Borrowing line item and that value would flow into initial commitment. So I have used ISFIRSTOCCURENCE with a logic IF Borrowing <> 0 THEN ISFIRSTOCCURRENCE(Borrowing, Revolver Facility) ELSE FALSE but this will giving me two occurrence. what I need is the…
I want to get the first month of a period set in module calender.
hi! I want to automatically display the first month of a calendar set in a module that has not been applied to. Can ido it？ Please help!
2.4.7.1 Create Demand Forecast Grid UX saved view
Hello, I really need some help for this step. I completed to first conditional formatting rule set up for Final Forecast line, but I have no idea how to set up the for Initial demand Forecast. In case, I attached example from training and how I set up and result that came out. Please help me with this. Thank you
Actual vs Plan Reporting Issue (Different grains = double-counts)
Hi All, I have the following 3 Modules: Module 1 - Staging (Actuals) Lists - Supplier, Service Category, Time, Line Items (Amount) Module 2 - Input Plan Data Lists - Supplier, Service Category, Maintenance Category, Time, Line Items (Amount), Versions Module 3 - Reporting Module Lists - Supplier, Service Category,…
Help Inform the future of Anaplan's APIs
Please take this short (less than 5-minute) survey to help inform the future of Anaplan's APIs.
Why unable to pull the app?
Hi Community, can anyone help to understand the reason behind this error? Post login received the below error (tried more than once).. Is this app no more valid? If so then is there any substitute of this app in hub?
Issue when importing from one module to another
Hi, I have an issue when importing data from one module to another, and the scenario is the following: I have a source module with "Projects" as dimension, and a target module, also with "Projects" as dimensions. The source module is a "calculator", where you can enter values and factors, which then calculates the final…
Dimensions: Time (Year)
How to change the Time to years
Registration for April Elevate Program?
Hi y'all, Does anyone know when the registration for the April Anaplan Elevate program will open? I want to make sure I don't accidentally miss it. Regards, Joshua
Disaggregation
Hi Community We are disaggregating data from L1 to L2 based on the past data. As a part of it we are getting decimal data in the L2s. We tried Round Off, But It is not matching the data of L1, due to round off. Is there any way to get the data in whole numbers, without losing the data. Thanks Badam
Formula Editor with AI suggestions
As a SA, when we perform the model review, one of the most common issues are badly written formula. MAT analysis does provide a list of potential issues. It would be nice to add another button in addition to apply as Suggest, so it can warn the users when they try to create complex formula. Even better, given the vast…
How to get previous value of line item which doesn't have time dimension
Hi, I have a use case where I'm using the custom time dimension list in which there is a line item called Beginning balance which is the previous value of the Ending Balance. So I'm stuck as there is not native time dimension being used in the module so I can't use previous function of Anaplan. Any work around is possible?…
Effective Line Items rename during Fiscal Year changes
Hello , For Every Fiscal year development, we used to copy the models and rename the line items in the modules / dashboards from FY21 to FY22 etc. Later it was discussed with the user and renamed CY, CY-1, CY-2 (CY = Current Year), but the users are getting confused with these CY terms. Have anyone tried a different format…
NEWUX: Dynamic Time Period Filter based off Line Item Selected
I am building a chart where users can select a line item as a selector on the chart and the values will display over time. However there a many time periods currently showing for certain line items with no data. I would like a way to dynamically filter to show periods from the first period containing a non zero value to…
Total Count for number of items based on parent and type
Hi I am having an accounts lists (A1,A2...A5,B1,B2...B5) with Parent(Accounts) as A,B and parent(parent(Accounts)) as X. Type of accounts are Type A, Type B. If user(A,B,X) selects an account then the number of accounts under the particular user with same type should be display in target. For example, if User A selects an…
Survey Invitation: BPM Pulse Research
From time to time, and as you well know, the analyst community will approach us for customer insights to inform industry-specific research. Today, we'd like to point you, our trusted power users, to the 2022 BPM Pulse survey. Your input will help to influence BPM Partners' annual Vendor Landscape Matrix for business…
Make the 'Referenced By' section of a Module Blueprint CLICKABLE
I want to be able to do the following: * Open a Module in Blueprint view * Scroll to the right to see the 'Referenced By' field of a Line Item * CLICK on this field and have one of two things happen:* If there is only one Line Item in the 'Reference By' the module with that Line Item opens (in Blueprint Mode) and (bonus…
number settings
Currently number settings can be done only at Line item level. It is cumbersome to repeat number settings across all lines in the modules in a model. Like Time and Version settings, can we have the option to set up Default Number Settings at a model level. Similarly, Rounding of numbers can be set up a default across the…
Propose to add Formula AutoComplete function
It would be great if Anaplan can have the Formula AutoComplete function just like what the Excel formula bar, so that user doesn't need to memorize all the formulas and general lists.
Allow for Copy/Paste of 'Reverenced By' to work in 'Model Search'
The new 'Model Search' is awesome! I use it all the time! I have noticed that it cannot handle a few search prompts. One of them is if the user pastes a full reference for a Line Item. An example might be 'CALC Store O4 Month Results'.Store Hours Threshold Pasting this in Model Search produces no hits. But the ideal result…
There has to be a better way. Any ideas?
Hello, While on a rebuilding project with a client, I am ready to delete some modules. Problem is the line items in those modules are used in Formulas and are connected to downstream modules. I know I can reference the specific references in the Blueprint view, and scrolling over to see the Referenced By column. However,…
Avoiding a large intermediary module
I have a list of transaction codes that a user wants to summarize in a report that replicates what they've produced in excel. The transaction codes don't form a natural hierarchy for this. The excel report pulls out various individual codes, groups some together, summarises others etc. To achieve this I've got a line item…
How to get first date of the model
Hi, Does anyone knows how to get the first date of the model? *The first date that comes from the time dimension I want to compare the first date of the model against date input by user.
Increase 1 million list item limit for Order list action
Requesting to increase the limit of 1 million list item count for Order list action. Currently we will get the following error when list item is over 1 million: Cannot Run ActionThe number of items in the list (1000001) exceeds the maximum allowed (1000000)
13.6.5 Activity: Add Column Chart to Margin Summary Page
Hello! I have the problem - i filtered the data with the rules given (forecasted months only), but i can't get the view needed The picture is below what i have What i need Also i notice that my view in the grid chart is also not correct - but when i changed it does not give me the chance to save with the same name What is…

Modeling

Discussion List