-
I cannot start Level2 spint2 learning
I completed the test with a 90% response rate. But I can't take the next step. What action do I need?
-
SUM for two line items (in the same module) that have a common list format
Hi, I'm trying to SUM two line items in a model - currently we have the below which works: THEN '[SUM: 'PL 1. P&L '] …. As we want to SUM two line items in the module, we have tried the below (and other SUM formats) but failed with the comment the line items have the same list format. If somebody could advise it would be…
-
How to lock a specific version?
I am looking for a way to lock a specific version so that numbers do not move for that specific version. I have used a version list in my modules instead of Anaplan's native version functionality. For example, I have three items in my versions list used in all modules- actual, budget and forecast and want to lock down the…
-
How much time does it take to restore a model to previous version
I have a model which is of 500 gb in size and I have restored it to a previous version. How much time will it take? It is already 30 minutes since its running.
-
How to pull together values from multiple modules
Looking to pull together values from multiple modules, which have started, as shown in the right hand screenshot. The difficulty I have is trying to pull the values across from a module such as INP08, shown on left hand side of screenshot below. Ideally I want to be able to pick up individual lines from this module into…
-
How can I unolock the locked Budget Version?
OK. So we wrote a budget, had it approved and locked down as the Budget Version in Anaplan. A few months later we decided to move some of our assets around, with an impact on the budget. We would like to change our Budget Version to reflect these changes. We can't unlock the Budget Version! How do we do this? Chris.
-
Apply Value only to certain list members where line item matches others in list.
Is there a way to apply a value to a certain list member and only the ones after, where a particular line item (where the adjustment was applied) is equal to? In my example, List members are shown in order. On Cell G13, 1500 was applied to Sales ID 11. H12-H16 reflects the additional 1500. Because Line 22-26 is also…
-
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
-
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:
-
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)
-
export Anaplan data decimals precision to PowerBI
Hi Anaplan Community, I am trying to export data from Anaplan into Power BI using the Anaplan Connector. I manage to get my values into PBI, however, I miss the decimals precision which I see in Anaplan. Example: in Anaplan my number format is set to show 3 decimal places, so 594.450 (US notation), five hundred ninety four…
-
Consolidating recursive modules
Hi I have 2 Lists and 3 modules as shown below. I want to build module 4 (details below) in the most efficient manner. Seeking ideas. Thanks in advance List: Employee ssL0Employee ssL1Employee ssL2Employee ssL3Employee Employee 1 Y Employee 2 Y Employee 3 Y Employee 4 Y Employee 5 Y Employee 6 Y Employee 7 Y Employee 8 Y…
-
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"…
-
Regarding anaplan workspace access
I have purchased a Anaplan work space but still its approval is pending can anyone follow up this issue please ..
-
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…
-
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…
-
API Authentication error bc of need to reset password
Hello, The IT team of a client has built a integration with the data base to Anaplan using the API. They have a problem of Authentication when Anaplan ask to reset the password, giving a 401 unauthorized, so they have to go to the Anaplan page and reset the password and make the changes on the integration. Is there any…
-
Anaplan New Workflow decision task
Hello all I have a question regarding the New Anaplan workflow . In the online course provided by Anaplan it says when a Decision Task is created and assigned for example to a user , when workflow starts that approver will see 3 option : Approve - Reject and Send back . i decided to create a Decision task but when it is…
-
Cell history not being captured correctly
Hi All, I have come across a weird scenario where cell history of a Boolean formatted line item is not getting captured properly. For e.g. : In the attached snippet of a cell history of a module below are updates 1 - Data got updated after a bulk import to TRUE (History ID - 3994882) 2 - In the next update (ID -3996409 )…
-
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…