-
Automatically Sort List Dimensions in "Applies To"
The Planual 2.01-11 states that dimension order should remain consistent among modules to ensure faster calculations so that common dimensions are in the same order as the applies to. I know I am able to click into the Applies To section for a module or line item and then click "OK", and that this will re-sort the list…
-
Summing a percentage of a list amount from one module to another
Here is my situation: I have a module that contains a $ amount for a list of accounts , I am then mapping those $ amounts to another module that contains line items that I have in a List. In my screenshot you can see in Line item Mapto contains values of the list as well as Line Item Mapto2 contains values of the same…
-
Formula error
In my Stat forecast I have some items mentioned as "End of Life" and it has a date until which the item will be active for forecast but after that date it will go inactive. But the formula that I have now isn't giving me forecast for that item. For e.g.- For Item A - EOL = Jan 2025. (so this should give forecast till Jan…
-
Workflow Notifications
Hello! I'm currently building out a workflow template using the new workflow feature. However, when I kickoff the workflow I receive about 10-15 emails. Is there a way to control the notifications that are sent to the end users? Thanks!
-
How to add colors to worksheet
My current worksheet has color highlight for some rows, now I want to create a new page and add highlight other rows with colors, how do I do that?
-
Experiencing Occasional 'Basic Authentication Failed' errors under SSO
We recently switched majority of our workspaces over from Basic Authentication to SSO for security. To populate our models with data that is rapidly changing we push data through our internal data store through an ETL (Workiva formerly known as OneCloud) hourly sometimes more often than that. There is a dedicated service…
-
Why does History show as <system user>?
can show up for a few reasons: [list=1] * When a model is first created the first entry in the History is * If Workflow is enabled on a list, any automatic change to workflow triggered by data changes will show up as . Eg. If a list item is set to workflow 'Not Started', any data a user enters into a cell relating to that…
-
Get the Sum of Column
Hi everyone. how can i get the sum of Lease Liability column in Module 1 and insert to Monthly column in Module 2 Module 1: Module 2:
-
Synchronize scrolling for grids
Hi team, The Synchronize scroll function allows you to group only up to 4 grids on a page. What are the solutions if you need to apply Synchronize scroll for 5 or 6 grids in one row on a page? Thanks
-
Importing older classic dashboards into Anaplan apps
Question When one imports a dashboard, is the original dashboard in classic lost, or is it still available after the import? My preference is to have both and then, after tweaking, I can manually delete the older dashboard. Thank you
-
Raised to the power of
Hi all. i want to achieve the formula with raised to the power of. I have this formula in excel which is =(S12/(1+($E$14/12))^(P12-1)) now how can i convert into anaplan formula? this is what i've got so far: Amount / (1 + 'REP00 SL Display Lease Details'.Implicit Rate / 12) ^ ('REP02 SL Lease Liability'.Period -1)
-
Regarding anaplan workspace access
I have purchased a Anaplan work space but still its approval is pending can anyone follow up this issue please ..
-
Better solution for a nested IF... but I can't think of one
I am working through many many modules and removing 'bad' data or process and have come across a nested If formula, and cannot think of a better way to replace it. Have a module with 2 sources MATERIAL and LABEL TYPE. Within the material list we have several labels (FRONT, REAR, DECAL + 6 others) In the module i need to…
-
Anaplan API 2.0 Python Library - [Updated March 2022]
* Getting Started * Gathering the Necessary Information * Authentication * Getting Anaplan Resource Information * Uploads * Executing Actions * Downloading a File * Get Available Workspaces and Models * Example Code After a significant amount of refactoring, I'm very pleased to announce the latest release of my Python…
-
selective access via formula's in module
Hi all, It would be helpful if we could control selective access via a sort of system module with booleans. This would allow a relatively standard import to update access that can be done by regular users if set up by the admin As well as enable some extended filtering capabilities and references per user to be made. all…
-
Avoid the roll back every time the formula is wrong
Every time we create a wrong formula the system runs a roll back that takes about 8 minutes!! We would like to avoid this roll back... it takes so much time during the development phase! They could just send a warning message!
-
Conditional Formatting on hierarchy levels
Hi, It would be a great feature to set up conditional formatting: 1. Either, even if summary method is turned to None; 2. Or based on the existence of one (or more) hierarchy levels Sometimes, users want aggregated levels of a hierarchy to be highlighted on a UX grid. You can set up a conditional formatting using some line…
-
Importing incorrect data into "Actual" version
I've built an import and mapping logic to bring my actual data into my Anaplan model and everything is correct on the line item "Actual Expenses" as shown below. However, when I run an import action to move this data from the "Actual Expenses" line item (where it is calculated) to the Actual version of the "Plan Expenses"…
-
Dynamic Cell Access by Role
I am looking for suggestions / alternative approaches for managing DCA by the user's assigned Role. Ideally, there would be an easy way to maintain this going forward. 1) I have heard a rumor that there is a trick wherein you somehow create a filtering module, then use the normal Roles>>Modules access assignments. Access…
-
Is there a way to change the purple text color for inputs to be blue?
In the new UX, the text in input cells is purple. Is there a way to change this default to be blue?
-
Counting a Project name
I am counting the project item(List: Project name) based and generating a unique number by adding +1 to count . everything is working fine until a situation comes where i have to delete some existing projects. When i delete the project → my count reduces and the way i am creating a unique number which is by +1 to my count…
-
Adding a parent hierarchy to the existing lists
I have a hierarchy of brands which was set up a year ago. Now I want to add a parent to L1 (i.e. L0.5) as a parent of all, which should separate all brands into Private Label and Owned. Because now when I build pages and I want to see only the owned brands altogether I can't do that as in the module the brands are listed…
-
Hi,After 90 days of trial period can't we access our model in Anaplan.com. Is there any way.
-
Copy paste formula from excel into Anaplan blueprint
Hi Anaplan community, I wanted to make a quick fix to existing formula in my Anaplan blueprint view, so I exported my blueprint view to Excel, used the find&replace functionality in excel to update all my formula at once, and then I wanted to paste back my formula in Anaplan blueprint view, but it gives me this error…
-
An 'Overall Total' label on top of a stacked column or chart
Description: I would like to add an "overall total" data label to the top of a stacked column or bar chart. Example: We are looking at whether our new Agreements come from Existing Customers, Previous Customers, or Brand New Customers. But I also want the overall total represented on the graph as a data label.…
-
Level 3 Line Items Not Populating
Could anyone explain why the Product Family and Account line items are not populating in my TAR01.1 module? I've got these formulas linking to a SYS module that I created. These two modules have the same dimensions.
-
Level 1 and 2 training
Hi All, I am new to Anaplan and have FP&A experience and i want to learn about model builder in anaplan. But i do not have Anaplan workspace access to practise the lessons. Yesterday Anaplan resumed their Talent builder program but to enroll in that program , you need to complete L 1, 2 and Anaplan way training. Need…
-
Cloudworks Reporting
Would like to see Cloudworks report detailing active integrations and their schedules
-
Find last month of the Quarter
Create a Boolean formatted line item in SYS Time module at month level. In the formula bar write the " PARENT(ITEM(Time)) <> NEXT(PARENT(ITEM(Time)))" That's it😉
-
Import Issues
Hi All, I'm currently facing two issues related to import. I have one module (split in three tables in UX) in which the user imports data. Here's the module: The import action works perfectly well for me but not for them. Apparently, the system is considering the comas as decimal separator while they consider it as…