Model Contributor

Straight Line Depreciation spread issue
Dear Model Builders, As per attached screenshot of my Straight Line Depreciation code, I am not able to get depreciation to calculate and spread for all subsequent months from Date in Use to Useful Life of the asset. All I am getting is a depreciation for a month of Date in Use but not for subsequent months. I have even…
Opening Capex Code not referencing Closing Capex correctly
Dear Model Builders, Please refer my attachd Opening Capex code which I believe not referring to the previous month's closing capex correctly. Appreciate your help on finding the cause of error and possible solutions. Thanks
How to reference a Time Period in an IF statement please?
My PRACTICE module has time dimension as Months 2019. I want to create an IF statement in the RESULT line item that says IF Time Period < Jul 19 THEN TEST 1 ELSE TEST 2 How do I reference the Time Period in the IF statement? i.e. how do I write the IF statement so that in the RESULT line item there is 250 from Jan 19 until…
Month Number respective month.
I want a line item where I can select the month by drop-down. For this respective month I need the number value of the month. How can I achieve this.? Like October is 10. I am thinking to create a month flat list and use it, but how can I get the number? And i would very appreciate you if you share screenshot.
Removing unnecessary Top Levels
Removing unnecessary Top Levels (or better yet, not adding them in the first place!) Author: Allison Slaught, Certified Master Anaplanner and Principle Solution Architect at Anaplan. To improve efficiency in your models, it’s important we only calculate where necessary. One way we can do that is to only use Top Levels…
Multiple Selection like Excel Pivot
I want publish this below list on ux pages and give end user option to select multiple item from list like we have option in Excel Pivot table. Is this function available in Anaplan or can anyone suggest me alternative function can be used. There are multiple line item in the list. The final goal is to sum the number from…
Models - Blank Screen
Hi Folks, I am getting this blank white screen which has been loading forever. I have cleared my cache, used different browsers, verified my access with administrator but still issue persists. Is anyone facing the same issue? And found solution?
Capture Current Date Time Stamp in a cell
Hello, I want to capture Current Date Time Stamp in a cell when there is a change in line item? Is it possible with out implementing something too fancy?
Share your feedback: modeling experience (deadline extended!!)
The product and UX team at Anaplan is looking for your feedback on your current modeling experience, specifically focused on building an appreciation for the challenges you face as a model builder in Anaplan. This survey is designed to capture this detail, so that we can explore how to simplify and accelerate the modeling…
Send an Email Notification if a Line Item Doesn't Equal 0
Is there a way to send a notification to specific users if a variance/line item is not equal to zero?
Spring cleaning your Anaplan experience: Best practices for model optimization
Author: Wendy Wen is a Certified Master Anaplanner and Senior Director at Globalization Partners. As we embrace the arrival of spring, it's an opportune moment to fine-tune your Anaplan experience, enhance model efficiency, and elevate user satisfaction. In this blog post, I will delve into essential best practices and…
Top Down Approach
Hi All, Check if you can help in the following scenario. I have 2 list PRODUCT & PRODUCT FAMILY (parent of product). Module 1 : (with PRODUCT as dimension) Line item : Check? (Boolean) User will select the product as needed. Module 2: (with product family as dimension) Line item : Check Product Family : ???? (if the…
3.4.3 Activity: Create Country Summary Module formula is wrong ?
hello I have put the formula for Safety Stock Flag Count but in the exam it says wrong when i pasted it . i dont why couple of times it got rejected ? any advice will be helpful
Getting to know your model
Author: Stacey Gibbens is a Certified Master Anaplanner and Anaplan Solution Architect, leading the Center of Excellence at Globe Life. Maybe you’re a new employee at a company who has been using Anaplan for a while, or maybe your company has contracted with an Anaplan partner to have some models built. Either way, it will…
Best practices for technical documentation of a model
Author: Arun Thakar, Certified Master Anaplanner and Vice President in the banking industry. As go-live approaches and admin and end user training gears up, the question of ‘how do we document the model?’ might be front and center in your daily standups. Fear not! This article will cover some of the best practices on…
Best Practice to combine two or more model data into one output model
Hello Team As project requirement I need to combine information from two different model (i.e. Actual Payroll information and Plan Payroll Information) In different model have calculated this information since calculation is different and in plan payroll end user will make the changes. List used in both models are number…
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?
Email Notification
I created a action - to add list member. Additionally also a notification to notify me via email if there will be a new List member added. But unfortunately it is showing me two different buttons to execute the process. Is there any way i can create in one process the adding of list member followed by Email notification?…
Time Problem ASAP
Hello everyone , I have an old model with a time scale of 2023 and 2024 and after that I wanted to add 2025 in the time , some models take in consideration the next year , others not ! Is there any of you who faced this issue before ? If yes can you provide me pleasewith the solution. For me : I doubt that the problem…
Excluding Ticked Booleans
Within a list, is it possible to create a list subset based out of formula to exclude ticked booleans from other list subset of the same list?
Aggregation Functions Other Than SUM
There are several types of functions in Anaplan: aggregation, numeric, financial, time and date, logical, text, call center planning, and miscellaneous functions. As a model contributor, you are probably already aware of the SUM function in Anaplan, which is an aggregation function, but how many other aggregation functions…
Show process Id into actions window
it's would be useful to display process Id into actions window (in a dedicated column)
Mapping modules dimensioned differently
I want to be able to pull over my Snapshots from SYS: Snapshot Lookup into my time module via lookup using my Week Number and the Code since they are both text. My lookup module isnt dimensioned by time but it shouldn't have to be, what am I missing?
L3 Sprint 2 building the list: G4 Territory > Account#
Hi Community, I started L3 wherein we have to build G4 Territory > Account# list in Sales Planning model I followed below steps as per training Firstly, loaded the Download: Territory Data.csv into Data Hub model into Territory Flat List system and built system module below is the image attached of both list and sys module…
Anaplan Last year values Summary(Formula)
I have two modules A, B. Module A has time ranges of Week, Month, Quarter, Year. Module B has time ranges of Month, Quarter, Year. What would be the best practice to get last year values from module A to Module B and have them reflected for Month, Quarter, Year? (I tried OFFSET, POST, but got error while changing summary…
I NEED HELP ASAP
Hello, I need your help please!! I wanna import this file CSV in a list on Anaplan without edit the file. should i import the file in a module and create a code for each line then import the view in the list ? and how to do it ? thank you RGDS
Formulating and capturing the no of orders count based on orders placed between time scale.
Hello Community, Process explanation based on below screenshot is basically on the left part we have module in which time is recorded for the orders placed and we need to gather and capture the count or no. of orders placed between the time series. EX: Orders between 14-15 PM is placed at 14.30 PM and 14.45 PM we need to…
Action for Deleting an empty row in UX after running the process
Hello community, I have been working on creation of the group wherein employees roll up to a particular super group below are the 2 Screenshot in detail. Current Process: Below is when enter all the details and click on action called "Create Super Group" the new employee with its Super Group code is added to the below Grid…
UX Page action button and Grid Data
Hello community, I have been working on creation of the group wherein employees roll up to a particular super group below are the 2 Screenshot in detail. Current Process: Below is when enter all the details and click on action called "Create Super Group" the new employee with its Super Group code is added to the below Grid…
3.4.3 Activity: Create Country Summary Module
Hello can anyone please help that formula for country made in is correct ?

Model Contributor

Discussion List