-
Produce random numbers
Hi, I was wondering if there is anyway to have random number generator? Thanks
-
RANDOM() function
Function that will generate random numbers, between specified min & max values. Excel has two functions to provide random numbers: RAND() generates a decimal value between 0 and 1 RANDBETWEEN( x , y ) generates an integer >= x and <= y It may be worth considering an extension to these functions such as: RANDOM( x , y , z)…
-
OEG Best Practice: Pre-allocation in lists (and impacts to model performance)
What is pre-allocation in lists? Pre-allocation in lists is a mechanism in Anaplan that adds a buffer to list lengths. It is not added by default for lists; it becomes enabled when a role is set on a list. Please follow 1.03-01 though. Only add roles when needed. When it is enabled, a 2 percent buffer is added to the list,…
-
Noted! Using model notes in Anaplan
Author: Hillary Sich is a Certified Master Anaplanner and Consultant Manager at Allitix. We use sticky notes, OneNote, Evernote…. Even if we can’t agree on the type of notes we use in everyday life, we can all agree that notes are an important tool. We use them for organization and communication. The big question here is,…
-
Variance impact calculator
Author: Anya Skvortsova is a Certified Master Anaplanner and CoE Lead at Asana. Purpose FP&A is often asked to calculate the impact of variables on the total variance. There is more than one way to go about it. I’d like to share a variety that uses the typical Salary/HC reporting modules output to define the contributions…
-
Level 2- Sprint 1- 1.3.6
Hey everyone, I am hoping someone would be able to provide some clarification for me. I am on lesson 1.3.6 of Sprint 1 for Level 2 and it states that the following items need to be in the saved view. What are the subset line items? "Include: Code, Parent, and subset line items" Thank You, Laura
-
Calculate Space Utilized depending on Format and cell count
Hello Anaplanners, I have small query regarding size calculation, like how size of model is calculated using cell count of lineitem depending upon format used.. I would be better if I can get example calculation explaining how size is calculated using different format. Thankyou
-
Calculating in a ragged hierarchy?
Does anyone know how to do a calculation in a ragged hierarchy which returns to the level of the hierarchy?
-
Ragged to Balanced Hierarchy
Please can someone give the step by step points in an easy way to convert a Ragged Hierarchy to Balanced Hierarchy in Anaplan. Thanks!
-
Filter the Hierarchy Level
Hello all. A few days ago I saw a "How I Built It " video regarding the Hierarchy filter which taught me how to use Ratio Summary for filtering . I wanted to replicate the same structure but here is the thing. I created a module for filtering Group level ( higher level ) or Product level ( Lower level ) like the picture…
-
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…
-
4.6.7 Activity: Import Data into P2 Products List
Let me know what am I doing wrong here. getting different result while importing.
-
Custom Switchover
Hi, I want to build a custom switchover for Fake version/List I created separately (Actual, Forecast, Rolling Forecast) I created a custom switchover time period 2. Then I created a custom switchover period 3. Next, I have the module where I want to apply the formula, however its showing Circular references: values Result…
-
How I Built It: Replacing the "group by" function of Excel in Anaplan
About the Author: Damien Bouquier has been a Certified Master Anaplanner for 5+ years and has developed solutions across a wide range of industries for FP&A, supply chain, and sales operations planning use cases. Hi Anaplan Community! Excel allows you to group and ungroup data areas to explore the data. Anaplan does not…
-
Copy a branch to another Parent.
I want to Copy a branch to another Parent. The hierarchy is 5 levels and i want to copy an item at level 3 and all its children to another item under level 2. All suggestions are appreciated!
-
Did You Know? Model building hacks
Author: Kirill Kuznetsov is a Certified Master Anaplanner and Solution Architect at Planingo. Hi fellow Anaplanners, Today I would like to share six model building hacks I use on a daily basis. This is not what can be found in Anaplan learning course — some of them I figured out myself, some are hidden in Anapedia, and…
-
Question 6 in level 1 model building exam
Could anyone who has finished the exam show me the formula for question 6? I failed 2 questions for this part. I think I just need to refer the relevant numbers from another module and apply selections, and then it could be done. However, my way didn't work. Here's my formulas. Thanks very much!
-
Activity : Filtering and Displaying Hierarchical Data
I want to create an interactive anaplan module that allows user to select an item from a hierarchical list and dynamically display associated items from the next level in the hierarchy Lists : P1 Product Family ( LVL 1) P2 Products ( LVL 2) P3 Products SKU ( LVL 3) Requirement : When a level 1 item is selected , display…
-
Creating iterations in Anaplan
Hey Everyone, I'm trying to find a solution in an excel sheet that utilizes an iteration function that I need to replicate in Anaplan. Basically, we take the previous number multiply it by 90%, then take that new number and multiply it again by 90%. For example, FY2024 is 28,940 FY2025 is 26,046 FY2026 is 23,441 (etc etc…
-
Separate into Several models
Hi. We will start a new project. In previous project, we made 1 model in 1 workspace. Off course, we have several models like (sand, test, Production model). It means we had several information in 1 model like (HR, Marketing so on..). Then, we can make separate models like HR model and Marketing models ? And We can share…
-
Level 2 Sprint 3 3.3.7.2
I am confused about what they are asking for in this section. The instructions say to Add DCA to INV01, which I did. But then there is a formula hint. I went back to Sprint 2 and rewatched the video for DCA. There was a quick reference saying you could add a formula line to the Access module. Is that what the directions…
-
User Access Management: Part 3 - Practice makes perfect!
If you missed the first two articles in this series, read Part 1 here and Part 2 here. This is a detailed walk-through (and a downloadable link to a practice model!) that you can follow to get started on your UAM journey. Note that the examples here leverage the Bulk API for adding new users to models. If you have enabled…
-
Driver Line Item for Action Button
I have condition in card where user can input negative value. But when the value is negative, the button will disable to click. I have data Product as Context Selector, Time Period Month in Column, and Line Item to input Order Quantity Review in Row. User will input number of order quantity review, but when the value is…
-
Lookup on Parent elements
ello anaplan Community, Hello anaplan Support, we stumbled upon a problem that seems to us like a functional error of anaplan. Example Setup: List "List_A": * A * B * C * D * E List "List_B" * a* aa * bb * b * c * d * e Module "Module_A" Lists: "List_A" Line-Items: * Value_B: Formula: B_Module.Value[LOOKUP: Lookup_B] *…
-
Referencing a list property
Hello fellow builders, I'm a bit hung up on this. I want the Display Name formula in the "Job Title by Cost Center" list to follow the same naming convention in the "Cost Center" list. For example, I want "BOBL-CAACPAY" to be "Accounts Payable (BOBL-CAACPAY)" The two lists are independent of each other, i.e. there is no…
-
IRR Function
I am attempting to calculate IRR on monthly loan cash flows, but my results are different to Excel and make no sense (e.g. Excel give 14.7% and Anaplan gives 418.80%) . All the examples I have seen (on Anapedia and in the Formulas and Functions app from App Hub) have annual cash flows, for which it seems to work. I have…
-
Function to Count Booleans
There are occasions in a model where I want to count the number of True or False boolean values. Currently the only way to achieve this is to have another line item with an IF THEN function to create a 1 or 0 and then sum the line item. It would be great to have a function to do this automatically.
-
Driver Line Item for UX Action Card - Not Working all of a sudden.
I've configured a series of UX action card with data write and Action runs driven by a driver line item . for approval workflows. All of a sudden the driver line items didnt seem to work and does not allow me to run the underlying process in the prod environment The Load invoice pricing card triggers an action run based on…
-
Optimiser for Minimising transport cost & transit Time:
Hi All, I've one situation where I need to build a optimizer which will minimise the transport cost & transit Time, Below are the details: Inputs : 1) Factory Supply Qty 2) Distribution center Capacity 3) Applicability of mode of transport from Factory to Distribution Center - Mode of Transport i.e by Air, By Road or water…
-
How to bring values in Length of Service line item?
Hi All, I am really struggling to bring values in the Length of Service line item. Since the module is not big I had first tried to manually select items from drop down for all Reps but I realized that it is not the best way. Can anybody please suggest something? Here are my model Normal View and Blueprint view