-
All of my DATA01 is cleared after 2019, is there any way I can fix this?
All of my DATA01 is cleared after 2019, is there any way I can fix this?
-
12.4.1 Activity: Create Saved View for Non Employee Expenses
Hi, for some reason my shipping costs are the same over every month and I don't know what to do to fix it.
-
Sorting in Combined Grids
Hi Team, I have been trying to apply a sort based on a column in one of the combined grids and seems like the option is disabled. Does anyone has any idea on this? Regards, Aakash Sachdeva
-
Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
-
Replace a line Item in the whole model
Is there any easy way to replace a Line Item in the whole model in all formulas? right now i have to check hundreds of modules to switch out a Line Item, which is quite tedious //GP
-
Anaplan Report page issue in the UX
Hello community, I have an issue with anaplan report (functionality). The issue I have is within couple of slides. The data in that report is scrolling into a new page. There is a hierarchy in the rows and line items and time in the columns. My problem is, the hierarchy is getting broken in the second page. One of the node…
-
Selective Access Challenge: Summarizing L3 Inputs at L1 Level Without Losing Granular Access
Hi Community, I’m working with a hierarchical list structure in Anaplan: L1 Region (e.g., Asia, Europe) L2 Country (e.g., India, Pakistan) L3 Local Input (e.g., Mumbai, Lahore, Islamabad) Users are given selective access only at the L3 level (specific cities like Mumbai, Lahore, etc.) so they can input data at those…
-
data import from module
I have source module having key (combination of location and department) as a dimension and target module has employee list as dimension. i want to pull amount from source to target that should remain same for all employee having that key (key added as line item in target module). what could be the best way to handle…
-
Solution for when 2 time dimensions needed
As shown in the screenshot, each monthly amount (Jan, Feb, Mar 2024) needs to be paid down in the future months (Jan–Aug 2025). The paydown must satisfy certain conditions specific to each month between Jan and Aug 2025. If the conditions are met, the paydown can occur. For example, if $20 is available to pay in Jan 2025…
-
How to get live small project for learning more.
I have completed level 2 certificate still I am not confident. I want practice more, where I get small project for practice.
-
Is there a way to auto-generate ID for user who entered line item?
In the UX, I want to be able to filter list members so end users can only see the list members they created/added. The users in this situation all have WSA access as this is a UX for our internal Anaplan team. These list members are currently being added by the form action in UX and I would like to avoid the user having to…
-
LOOKUP and FIRSTNONBLANK used in the same formula
I have two modules in Anaplan: Module 1: Name: dat_Fund Composite Dimension (List): ad_Fund Composite ID Module 2: Name: dat_Segment Dimension (List): ad_Segment ID There is no direct relationship or mapping between the two list dimensions. I'm trying to understand how the following formula works: Line Item: L0 Segment ID…
-
Capacity Model
Hi I am fairly new to anaplan and this is most likely the most basic question but I have created a model that indicates the number of "working days" within a calender period - my aim is to get the number of Days in a particular month that we have available to work. I have created the below model to get number of working…
-
Sorting Composite Hierarchies in Anaplan – Including Parent Items
I'm working with a composite hierarchy list in Anaplan for P&L reporting. The structure includes parent items like "Total Revenue" and "Total Purchases", each with their respective child items (e.g., "Revenue from Sales", "Revenue from Miscellaneous", etc.). I've implemented a Sort Order property to sort the list, but it…
-
How to bring Historical forecasts and actuals from the old SKU to new SKU
Hi Team , I am looking for the ideas to bring historical forecasts and actuals from the old SKU to new SKU . The Idea is we have NPI product which is actually a successor of the Old SKU with difference in some aspects such as packaging size. I want bring all the Historical data associated with old SKU to new SKU by some…
-
Polaris workaround for FIRSTNONBLANK
Polaris doesn't support FIRSTNONBLANK as a function parameter. I have a solution workaround for this already but not too happy with it. So wanted to know what solution workaround people have done to get around this limitation
-
How do I create a "Dynamic Bulk Copy" Action?
I'm looking to create a bulk copy action that allows me to select the source and target list items at runtime / when the action is run. I have some vague recollection I saw this available at one point with my own eyes, but everywhere I look on Community I find old posts that refer to the feature not existing. However, I do…
-
2 lists
I have a list with 5000 items. But If I want to add this list as a dimension in a module, the module is too big. Now, I don't need all 5000 items so I created a second list that has the 50 items I need. Then I can make a module CAL06 with all the dimensions I need. It's not too big anymore. So far so good In this module…
-
Is it possible to release single breakback cell in UX?
Hi, I have a question. When working in the module, there are three breakback-related options available, but in UX I can only perform 'Release all'. Is there any way to enable 'Release' for a single cell in UX as well?
-
How do I get the lowest value of all the years?
Hello, I need help in getting the lowest value of all the years. see screenshot below : I need to get the value -1,249,884 since that is the lowest Thanks