Modeling

10.2.1 Activity: Add Non Employee Expenses Module
I'm currently trying to add the formula for the Total row, and I'm wondering why the SUM and LOOKUP formulas I've tried are invalid or not working. Here are the formulas I've plugged in so far: 'OTH01 Non Employee Expenses'.Total[SUM:'OTH01 Non Employee Expenses'.Shipping Costs, SUM:'OTH01 Non Employee Expenses'.Rent,…
How to create a loop formula
Hi everyone, I am stuck on a formula. I have demands for 2021 and I need to calculate the demand forecast until 2030 by using the formula below Demand 2022= Demand 2021*Growth rate 2022 Demand 2023= Demand 2022*Growth rate 2023 . . . So how can I do that? Thank you!
Converting a list to another list
Hi everyone, I recently discovered something within Anaplan that has made my life a lot easier when uploading data. For reference, I work at a mid-size firm and we have data that comes from our accounting software, and data that comes from our enterprise reporting software. Sometimes the naming conventions of things are…
Two Ratio summary - Different for Line items and Time.
Hi Team, Can we have to different Ratio summary for both line items and time. it will be helpful in few scenarios where we have to calculate ratios have to be calculated differently for line items and time. Thanks, Manjunath
Quarter Apportionment
Hi Team, I have couple of queries regarding the below snapshot * Both Q1 & Q2 has 91 days, however the quarter balance is different? Can anyone explain the difference? * Are we calculating values for quarters first, & then segregating the quarterly values into monthly or is the other way around? * What does "Quarter…
How to calculate based upon a range?
Hi Team, Can anyone please help here to make the Commission calculated based upon the range defined in 1 system module? Second last column in 2nd module (besides commission) to be referred in above defined module.. and whichever range the % is falling.. that commission% must be referred in the below module.. Much…
Formula to end time
Hi I have this formula that will add 1(digit) to the months following the current start month however I would like it to stop adding number after month 23. I can't figure out how to end the argument/formula so it stops adding number. Ex: Current month is 0, Next month is 1, following month is 2 etc, last month should be…
My model building experience in Anaplan, featuring Colin Dowda
Over the past two years of model building in Anaplan, I’ve worked on SPM, ICM, FP&A, higher ed (enrollment), and supply chain use cases. I’ve worked with clients in healthcare, consumer goods, education, and tech, successfully standing up solutions for complex (and simple) problems. That doesn’t mean I haven’t had…
Quarter calculation
Hi Team, Can anyone explain me this calculation? This calculation amounts to 102% instead of 100% As per my understanding, it should be 31/90 = 34% 28/90 = 21% 31/90 = 34% Still, I'm short by 1%. Can anyone explain Also, can anyone confirm what is "Quarter Apportionment"? Is it no. of days by each quarter? 2022 Even as per…
New UX IDEA - Show/Hide for individual combinations of items in nested dimentions of a module
This will be nice to have Show/Hide feature options to select between Every occurrences or Selected like we have in classic UX. Currently New UX Show/Hide feature acts like "Every occurrence" only.
Code Generation on duplicate information entered by users.
Hey Folks, I am trying to generate code in the module in which user list is already applied, due to request from the team I want if the same information is entered by the user1 and use2 it should update the counter accordingly surpassing the users. for ex. if I have user 1 entered information as "abc" so the generated code…
How to calculate the total amount without using Select function
Hi All, I have created a module with two list (Company list: A,B,C) and Fruit list (Apple, Orange, Pineapple) Let say company A and C are tier 1 and company B is tier 2 And then i have created another module without any list dimension but just only a line item, how can i calculate the total amount of Apple selling by tier…
Error with copying formula over
"Invalid formula for 'REP03 Profit & Loss Report'.Car Costs: Automatic sum of 'EMP02 Employee Expenses'.Car Costs over ---Subsets--- hierarchy is not possible as ---Subsets--- does not have a built-in top level" I keep getting this error when pasting a formula in from the learning center.
Level 1 Activity 6 - No Medical Costs
Hi All, Desperately need help here! Why only the one field is not returning the results? EMP02 - Formula & Results In my REP04 File Results and Formula
Where can I download Level 3 Data hub and Starter Models?
Hello, I just started my L3 training, Where can I download Level 3 Data hub and Starter Models? The training doesn't seem to talk about it. Thanks!
New to the Forum
Greetings everyone, I am new here. I am new to Anaplan as well. I completed Level 1 and Level 2 training in December and I am happy to report I am now working as an Anaplan Analyst. I do not have a data background I actually was an insurance adjuster for 15 years, so this is a different path for me. In all transparency ,…
New Formula Idea : Convert boolean into a number and stop IF BOOLEAN THEN X ELSE XX
Hello community, I have to do a lot of controls (boolean) and base and theses controls give me a value based on its true or not. I do a lot of these technicals line items for : -Controlling element -Color Coding -... I code it in 3 steps : * 1) Business Element (Number) : Uselly a business value * 2) Control (Boolean) :…
Child with multiple parents
Trying to make a heirarchy where a child is having multiple parents Trying to fix it out .How do we suppose to import without getting any error
How to get the total amount without using Select Function
Hi All, I have created a module with a list 'Fruit" and a list with 3 list item "A, B and C" Afterward i have created the second module only include a line item and without and two list mentioned above. How can i get the amount of Apple in A without using the function of select? Since i would like to reduce the size of…
Anaplan L1 MB part 4
Not sure if this asking dic'2020 or FY2020?
L1 Error MB test
Hi, I was about to complete the anaplan test. And was told that we have two trials, for some reason my account appears as If I have already used an attempt. Can someone help me pls? 🙂
3.3.5.1 Create Inventory Ordering Module
Hi, may i know how to i import TRA01 to DAT02? Anything part which i may have miss out? not sure why my data is 0
Undocking in New FX
It would be helpful if the new user experience allowed you to undock tab's like you where able to in the classic interface.
Import a time range
As a model builder, I would like to be able to Import settings into Time Ranges. This would enable me to make Time Ranges more sustainable by driving their settings from an Admin Screen with actions.
reset times for minor issues are becoming a major pain i Anaplan
13 minutes because i used number instead of text as a format !! Surely this can be prevented, it makes developing a very slow process and stops a very busy office from working. Are we supposed to develop out of hours????
Dependent Pick List for Line Item Subset
Hi, I'm trying to set up a dependent pick list for one of my line items. I have set up the combo list with properties. The pick list is a line item subset. I'm not getting the option to create a dependency for my pick list despite seemingly setting is up correctly. Are LIS pick lists not able to be dependent?
How Do I View if a Line Item Has Been Used as a Filter?
Hello, I am doing some model clean up from a previous development team, and am trying to remove extraneous line items from the Anaplan model. Is there a way to view if a line item is currently being used to filter a dashboard, or module somewhere in the model? If not, that might be a neat enhancement, similar to the…
Azure Cloudworks navigation
Hi, At the moment its quit difficult to navigate through Azure Cloudworks processes and imports/exports. We are planning of having around 70 - 80 different integrations. Only thing what we are doing is naming Process names by numbers, but even so, number order is not working in all cases. It would be great if there could…
Look Up Not Working
Hi Community, I have a source module with dimensions of P2 (P1 is the parent of P2), In the target I have a dimensions of D1. I have one to one mapping done from D1 to P1 in a separate line item with dimensions as D1 and formatting as P1. When I use lookup formulae the data is not coming to target module. Any reason why…
Depreciation Straight Line method
I am Trying to calculate Depreciation by straight line method. But I don't know which function to use. It would be very nice if you me best method for calculation of the same. Thank you in Advance

Modeling

Discussion List