-
How to divide a list item value by the total list items value ?
-
Having more than three dimensions in the pivoting of modules
Hello, Is there a way to have more than three dimensions as rows or columns when pivoting a module? Maybe it is easier with an example, I have to create a report that requires 3 categories on top of the line items, but I am only able to add 2 categories, because the pivoting cannot exceed three dimensions in rows and…
-
Log of user activities
Hi, We have a requirement in which details of changes need to be captured. For example, when user created a new request on Anaplan, we'd like to capture the user who created this request automatically without user input. Our current design require imports. I'm wondering if anyone has done something similar without imports.…
-
Prior Year Value: Page selector?
How can I view the actuals for a previous year, regardless of the current year? For example, if if July 2023 is selected, I want to see the full year 2022 actuals. Similarly, if July 2024 is selected, I want to see the full year actuals of 2023. My current logic is only working for 2022 actuals. Actuals = Amount [Lookup:…
-
How to hide line items in UX avoiding repetitive hide UX command
Hi all, I am facing an issue I'm pretty sure many of you already have dealt with. The columns Cost Center, Responsible, Employee Name, Labor Cost are line items. I wish I could show the cost center, responsible, employee name, labor cost line items only for the first project (1-Av-Bc - Argus V1); in short, I need to go…
-
How to clear dependent dropdown selection without error
Hi, I have created dependent drop down list line item. . See below example data entered by user. Activity is based on Project. Activity Project Activity A Project A Activity A Project A Later user changed Activity value to Activity B and forgot to change the related Project. But Project is still having value based on…
-
Disadvantages of Numbered list
Can someone elaborate the Disadvantages of Numbered list
-
can we have a multi select filter as a page selector in Anaplan?
similar to what we have in excel filtering…can we use page selectors to select multiple boolean formatted line items. Snapshot attached
-
Add a list item from a module
Hi all, I am struggling a bit to find a way to add a new list item from a module. So, I have this module in which I let the user insert the product, the product code and finally the customer group; the final result are three new list items I need to add to the relative list, that is ps01 product (which is a numbered list…
-
Percentage of Parent and Parents Parent
Hi all, I am trying to find a way to calculate the Sales % of a items parent, and also of the Parent of the items parent. Below is an example of what I am trying to achieve,
-
Seeking Advice: Establishing a unified organizational structure & managing restatements
Hello, I work at a company's headquarters, where we use Anaplan for reporting purposes. Some of these Anaplan models have been developed in-house, while others have been created by external consultants. This has resulted in a situation where we have multiple lists containing more or less identical organizational…
-
can build a action that updates current month in time dimension of both hub and spoke?
Hello everyone, Can we create a action that updates current month in time dimension of both hub and spoke. Thanks, Maithri.
-
Changing formula scope does not re-apply to line items?
I have a formula which was written with the formula scope set to 'All Versions', then realised that I only need it to apply to 'Current Version', so I changed the scope but the data is still showing in the actuals and the forecast (all versions). If i add a new line item and set the scope first, and then use the exact same…
-
Cumulate a moving target
Hey Anaplanners! Hopefully a fun one and not just my own short-circuiting. I'm working through a capacity allocation rankcumulate, where my list items(SKUs) have a target for a month, and multiple sites that can produce units towards that target. My issue is that the cumulation is correctly grouping by SKU group (family)…
-
Button on Dashboard not working
The picture above highlights the problem, every time i use the button Add Sub-GL/Vendor Item, the chart to the right should update with the name, GL account, for each department. I tried to add a new vendor expense under admin finance and legal called "anaplan", the gl account i choose was called software/subscriptions.…
-
Add a button to a dashboard
I have dashboards built out for budget owners in the model layer not app layer of anaplan. I would like to add a button that essentially gives the budget owner the option to add an additional FTE to their headcount and plug in the respective salary of the new hire and see the financial effect of adding one additional…
-
Importing module
Hey community, hope you can help me with these one. In my Data Hub model I have a module to fed the others which includes different columns such as CCs, Accounts, Entities, etc. For the CCs specifically I create a mapping module which map some CCs to their parent level (these to avoid creating too many cost centers on the…
-
what is the difference of SUM ,LookUP, Select
-
What is Data Integration , any example scenario?
-
What are the best Practices for model building , how can i list out. I am in training level.