Hi Team, We have recently completed our annual FP&A planning cycle and now have a FY21 budget (Jul20 to Jun21) locked down. I'm creating our new FP&A model which will be a Rolling Forecast & also have…
As more people outside of the Anaplan ecosystem hear about the power of our platform, they're asking, "How can I get involved?" We recently spoke to two such individuals who took an interest in Anapla…
Hi I have a list and I am trying to drag products into a top product, however, I am getting errors: "Moving an item onto itself or one of its children is not allowed" and when I remove the parent and …
Hi Friends, I have a Module from which I want to delete the highlighted records. But without using filter or saved view. I can use any formula to do so. Is is possible by any chance? Kindly help me, i…
Hi, How can I replace my existing list with new one so that D4 should not appear in the list. why i am raising this question is because when I am importing the new list, D4 is still appearing in it wh…
Hi,everyone. I would like to reduce the cell capacity by reducing the module "Applies To". "List A", "List B", and "Item List" are set in "Applies To" of "Module A". Time Scale is Month. "List B-Flg1 …
Hi Can you provide some help here? My requirement is to create a General list and populate the data of list properties into another module. I set up a General List ' comp_pro_po' and uploaded the data…
Hi Community, There is a use case we were provided, so data was loaded against 2 dimensions with a custom period list also in a separate module the start and end date of each period is provided the st…
I have model calendar as week 4-4-5,4-5-4,5-4-4 and has day list with list items as Monday, Tuesday.... to sunday. So some days of last week in January are falling into February and so on. So I have t…
“Rule 2.04-03": Article 2, Chapter 4, and Rule 3 – “Keep the default view clean”. “Keep the default view as is, no hiding, filtering, or conditional formatting. It goes against AUDITABALE elements of …
As a model builder, I need to be able to easily apply Anaplan best practices such as assigning a functional area and providing a brief description of the purpose of my newly created module so my model…
Being an Anaplan user, I would like to dynamically set list management access without admin license. Similarly to WorkFlow and DCA, it would be great to have an ability to dynamically limit add/delete…
Hi Anaplan Community, Currently it is not possible to use a summary top level of a list subset or line item subset in a calculation without using a workaround using a boolean and using the complete li…
Hi, In my module I have a line item that holds the value for Period when the Actuals should have the data. I have time dimension in columns by months Is there a way I can write a formula and compare f…
Hi Team, We get request from customers where they have multiple versions of Budget like maintaining it quarterly. Like Budget should be open like * Budget V1 : Jan Onwards * Budget V2: April Onwards *…
“Rule 2.02-19": Article 2, Chapter 2, and Rule 19 – “Don’t daisy chain”. “Always refer back to the ultimate source if possible, to avoid creating more dependencies than necessary. This allows more par…
i hv created a list with different properties and want to update some properties when end user done some changes in the property published on dashboard and same gets updated in the list. i hv created …
"Textlist" is one of my favorite formulas when trying to reduce sparsity in calculations. However, Source[TEXTLIST: Mapping] becomes ineffective because there isn't the option to rollup unique values.…
How can I get maximum value for any line item. Dimensions are, days in a year ( 1, 2, 3....) and Item numbers 123456789101112131415Item 1023456700000000Item 20000567891011121300Item 30004567890000015
Hello everyone, The below screenshot is from one of the mini videos of Anaplan. How can one adjust the "Summary Settings" to get the number of days in a quarter or a year? I know of 2 ways to return t…
Hi Guys, I need some assistance on what approach to use here. Below is the description. The clients report consists on a table where they input the No. of Bldgs. and on another report those numbers of…
Hi Community, I require your help in-order to calculate Standard Deviation. The detailed overview of what I am trying to achieve is described below: I need to calculate Standard Deviation for Daily Sa…
My module is dimensioned with a numbered list, let's say Segment>Product#; I'm trying to retrieve the hierarchical parent from another list P2 Product in order to get the product family for each singl…
“Rule 2.02-17": Article 2, Chapter 2, and Rule 17 – “Put the most common condition first”. “For formula efficiency, put the conditional with the most common occurrence first in the formula. It goes ag…
Hi Anaplanners, Let's say we have a module with Dimensions A and B, they have 1000 list members each (for example), and a couple of line items, which user populates manually. Only ONE combination (int…
Hi, I have a module with 3 different list formatted LIs and an amount line item. I want to sum the amount in the module basis these line items such that any list item that has these 3 properties simil…
