-
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…
-
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…
-
Dynamic filter on a hierarchy
Hi, I built a dynamic filter on a dashboard so users can select multiple criteria. On the department filter, the end-user can only select the bottom level of the hierarchy and not a parent. This is because the filter is dimensioned by the lowest level of the department hierarchy. What's the solution to get around this…
-
How are you configuring workflow?
Hi Anaplanners - I am in search of process improvements to workflow. Who's willing to share their success with establishing workflow for approvals that encompass some derivative of: * required date field * required approve OR reject field * email notification submission * submission button Key considerations are: user…
-
Salesforce CRM Analytics to Anaplan Connector?
Hi all Anaplanners, Does anyone know how to connect Salesforce CRM Analytics to Anaplan to enable one way/two way data transfer? Thanks, Jim
-
'Manage models' - ability to sort by Name / Date Created / Size
After each planning cycle or major model change, we make a backup of our models. This of course has led to a number of archived models which usually save in order of date created at the bottom. Please can we add the ability to sort by Name or Date Created or Size. This would really help in looking for a particular model we…
-
How to get access of Anaplan for learning purpose?
-
Time text format?
Hello everyone, I hope you are all doing well. I am writing today to inquire about the best formula to transform text from the format DD/MM/YYYY to DDMMYYYY. For example: 02/04/2024 should be transformed to 02042024. Thank you!
-
Can anyone give me access to anaplan? As trial is on hold and i need it for practice purpose