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 formattin…
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 lear…
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 ye…
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 …
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…
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…
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, Mainte…
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 …
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…
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
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 …
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 addi…
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 …
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, …
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 wi…
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…
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 t…
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:*…
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 op…
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.
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 migh…
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…
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 r…
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.
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…
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 i…
Can anyone explain why I'm not getting the view as displayed in the instructions? My screenshots show my saved view, the view after the import, and what it should look like. Thanks!
