-
Anaplan Agile App - New UX
Hello, Are there any downloadable NUX pages/reports available to accompany the Anaplan Agile App to ease use, or is this all managed within the model itself? Any help would be much appreciated. Many thanks, Becky
-
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 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…
-
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 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…
-
Formula Question
Hi, I'm trying to create a formula that will pull values in accordance to each weekday. Below is the Formula I'm currently using. I have screen shots of the Modules I'm pulling from as well. If you need more information on the topic please let me know. 'D01 Funding Ratios'.Average of Fund * '01S03 Weekday count by…
-
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.
-
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 )…
-
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…
-
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:
-
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 ..
-
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…
-
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…
-
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…
-
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!
-
How to lookup currency from module based on selected filter
how can i lookup the currency rate based on filter that i selected in REP01 Long Term Loan Payable. General List: LO05 Currency Module: SYS03 Foreign Exchange Module: REP01 Long Term Loan Payable
-
Adding a list (as a page) into a pre-existing module
Hi. In one of our modules, are current pivot set up is: Pages: Version Rows: Line Items However, we need to add a list '# Customer' into Pages, to get the below pivot view: Pages: Version, #Customer Rows: Line Items Is this possible without creating an orphan/ duplicate module? TIA. Josh
-
Need count to work dynamically depending on the list size
Hi, I have a requirement where in a module i have 4 dimensions (2 as page filter, 2 in the rows), Also line items are on column. (No time as dimension) I need to have a formula where it should reflect count of the line item starting from 1 to as many as the line item count is. And this should be dynamic based on the…
-
Numbered Lists (With a parent)
Hi, I have created a numbered list (# Customer Number) successfully (with no parent, code as customer code, and name as customer code name). I'm trying to now create a numbered list as a child of customer number called '# Customer Name'. I bought in the below on the import: Parent Name Code Parent > the same code as noted…
-
General Question on Locking the Actuals
Hi All, How do you manage the master data changes? As the changes in anaplan are retrospective. Lets say there is a change in the master data and it will impact the actual numbers reported. Is there any native way to lock the numbers? Please don't recommend the snapshotting process as it will not be sustainable for my…
-
How does one safeguard against losing data with changing current fiscal years
I would like to use the out of the box TIME dimension/logic. However, I do have concerns about losing data if a fellow model builder inadvertenly changes the current fiscal year. How have others handled this situation? We have considered building exports to backup these modules every night and store the data outside of…
-
Data Loss with Inroducing Time Range
So in the current setup, a module is dimensioned by Model- calendar time dimension and the horzion is from 2021 to 2026, the granularity being weeks. This setup is used in prod since go live for 2 years now. We realised the span of time for data in that particular module can be reduced. Idea now is to introduce a time…
-
Using SUM to map data from a parent to a child in the same hierarchy
Is it possible to map data at say level 3 in a hierarchy to a level 5 item using SUM function? I keep receiving a 'Level mismatch on common dimension' error so I assume this is not!! Thanks, Chris
-
Can ANY be used where the source contains TIME dimension?
Hi All, I am try to query the presence of a list item in a source mapping where the source contains TIME dimension. Source contains one list combined with TIME where a mapping can differ across a year. I want to query this mapping to determine if a target list is in use at any point during that time period. I use this…
-
Create a number sequent in a period column.
Hi everyone. what is the formula on adding a number sequent in one column like 1,2,3,4,5 etc. i tried RANKCUMULATE but it returns all 1. by the way this result was already filtered. thank you.