-
Incorrect % line item summary
Hello Everyone, I've a list with 10 members where each member has a value of 10%. The summary for this line item shows 0.999.. instead of 1 in the backend. When I'm comparing the summary with 1 it gives me incorrect value. Does anyone know the reason for this? The summary is correct as 1 when the value entered is 50% for 2…
-
Make one list as parent of a different hierarchy list
I have a concatenated list P5_L5 that is rolling up to P4 list. Now I have created a system module with P5_L5 list and defined P5_L5 name, code, P4, P3,P2,P1 as parent. Then defined L5 using Finditem and then added L4,L3,L2,L1 as parent of L5. Now I want to create a list where P5_L5 can be assigned under L5 (L5 as a parent…
-
List Subset best practices
Let’s say I have a list, “List A”, and I have a list subset called, “Subset 1”. I have member 1, 2, 3 are part of the subset. I have created a system module where I can import into the SS. Can I import true into record 1, 2 and false for 3 to remove it from the SS?
-
How to Efficiently Manage Version Control in Anaplan Models?
Hi everyone I've been working with Anaplan for a few months now and am getting more comfortable with its functionalities. However, I’m facing some challenges with version control in our Anaplan models. We often have to make updates and changes, and ensuring that these are managed efficiently without disrupting our live…
-
I need to add two lists of same hierarchy in a module dimension
here Abc and Xyz is a part of P2 list Abc1,2,3 and XyzXyz1,2 3 is their child P5 level respectively. Now how can I add both the lists in dimension in such a way iit will show only their respective child's I have created a list where I defined P5 and added P2 as parent and updated from a System module where we defined P2…
-
ISFIRSTOCCURRENCE not providing the correct result
Hi Anaplanners, I was trying to setup a simple isfirstoccurrence formula and I couldn't get to the correct result: In screenshot below, I have the module dimensioned by #P3b_Child Territory, which has a parent. I want to use the isfirstoccurrence formula to only show true for the first appearance of "Americas" in the LI…
-
Is there a way to get a timestamp automatically added to an export file name
It would be super helpful to have the timestamp as part of the export file name in Anaplan, especially when clients run reports every day during the budget season. Is it possible to do? And do automatically?
-
Boolean oriented Show/Hide & Variance
Given a module which has Time(quarter) dimension, Total $ (line item), Scenarios(list, dynamically user created). On a dashboard view, how can we let user choose which Scenario they want to see based on boolean and create variances of selected scenario?
-
Level 1 8.5.3 Volume Inputs
I thought I did everything correctly, received successful confirmation that it uploaded. However, data does not match source data. What am I doing wrong?
-
I have a source module that has FY time period (eg- FY25 to FY29) and target module have
I have a source module that has FY time period (eg- FY25 to FY29) and target module have dimension with product and country as other dimension. I am not able to connect as getting Time format error. I have selected Period- YY in the mapping. Please help.
-
Formula to Calculate the Representative Week (number) for each Date
I need to calculate which date each week represents, I have a Weeks Attribute Module. I have tried some formulas but they did not work. I would really appreciate if someone could give me some advice or a direction.😊
-
What is the best way to secure employee salary data to a central admin?
Hello - We are designing our first FP&A model and currently employee data is within that model. We would like only one person in the organization to be able to have access to all company salary data to keep detail by person secure to all other users. The issue we are running into is if you have a model builder role, you…
-
Get the cell value data to based on dimension
Here in the same module . where line item having no's. Other line item is input. if the no is same then then first input value should should return Thanks
-
Why one option in a dropdown list can not be selected!
Not sure any body has same experience. I have a numbered list, and is used as format for a line item. And set filter of this line item as Selective Access and Dependent. Then I can find all these option as drop down list, but can not select the last option in the list (marked as red color). Mouse can move over this option…
-
Help Needed with COUNTIF Equivalent Formula in Anaplan
Hi Anaplanners, I have a doubt about Anaplan. I know it's a silly question, but I'm not able to solve it in Anaplan. If anyone has an idea, please explain it to me. I have attached a screenshot to this post for reference. Problem:In Excel, please refer to the N column, which is already highlighted. They are using the…
-
alternative hierarchy
Hi Anaplan community, I get a request from the business to add another view to the aggregation of the organizational hierarchy in an existing model. Currently we have a couple of sites, rolling up into platforms, rolling up into "Global Manufacturing" or "Global Overhead". This is currently setup using hierarchical lists…
-
Anaplan Optimizer - Balanced Allocation
Hello everyone, Really hoping one of you bright-minded individuals can help me progress on a persistent issue. I am essentially doing a replica of the "T1.3 Allocation with Product & Line Compatibility" from the Optimizer Toolbox: But! My objective is not to minimize cost. Instead I have a guideline allocation of the…
-
How to perform different calculations across list members in a hierarchy?
I came across the following situation and wanted to get more input on how others might handle this. If I am looking at a standard P&L hierarchy where the P&L lines are list members, is there a simple way to use Anaplan to calculate a line item differently for different list members (that doesn't involve long nested IF…
-
Anaplan users and inherited user rights for models in the same workspace (workspace admin)
Hi I think Anaplan should change the inherited access rights to models in workspaces. When creating users, it is easy to give a user access level when creating a user BUT the problem is this becomes inherited in other models in the same workspace. There is a workaround - give no access when setting up the user then specify…
-
Real estate financial modeling
I am currently working on building a real estate financial model from scratch on Anaplan, focusing on either acquisition, renovation, and development modelling or a simple condo development model. I seek guidance and references for creating these models on Anaplan.