I am needing to calculate the number of months between two dates, one of the dates falls outside of the model time range. I am needing this so I can do a straight line depreciation cacluation but the …
If you have a multi-year model where the date range for different parts of the model varies (for example, history covering two years, current year forecast, and three planning years), then time ranges…
Hello everyone, I encounter a problem concerning the formula of "Offset Volumes for 1st Forecast Year" . I wrote the formula that seems logical to me but it doesn't work. Can someone help me correctin…
Hi All, I'm trying to add all users with selective access to in CC of an email to be send via "MAILTO". But can't seem to get it working. Did anybody already try something similar? Thanks,
Author: Ekaterina Garina is a Certified Master Anaplanner and EPM Consultant at Keyrus. Does your Anaplan model feel cluttered with too many line items and modules, making it difficult to find anythin…
In the world of Anaplan modeling, performance is key. Slow model calculations can be a major bottleneck, impacting productivity and decision-making. But what if you could pinpoint exactly what’s causi…
Description of the enhancement required: Version as a format An example of the enhancement: When uploading a planning file (budget, Q1 forecast, Q2 forecast) from excel, a number of identifiers for my…
Versions are useful as they allow switchover functionality enabling a user to both enter a forecast on a line and see actuals in the same line item. However, comparing versions to eachother (any versi…
Author: Mike Henderson is a Principal Solution Architect at Anaplan. There is growing interest in taking existing models that operate in the classic (Hyperblock) engine to Polaris. There are a variety…
Hi Anaplanners, Hope you all are doing good! I have one question regarding export. Lets say we have module dimensioned with 4 dimension . And we cannot add 4 dimension in row. I have added time dimens…
Hello everyone. My case is simple : For a specific client need, I have a list with date property. Each time a date is input in the module, a process is run to "save" the input in the lists properties.…
It would be very useful to have this functionality rather than convert to numbers through DAY, MONTH, YEAR and back to text through TEXT function. Best practice would dictate to split these functions …
As configurações de tempo no Anaplan vão muito além de uma etapa inicial de configuração, elas representam uma das principais dimensões em um modelo padrão. Com exceção dos modelos do tipo Data Hub, a…
Author: Fabien Junod is a Certified Master Anaplanner and Senior Solution Architect at Autodesk. Hello Anaplan Community, Let me ask you a question: do you have the same complex calculation in multipl…
I’m working on a page that includes two tables: Module 1 (called CRM Table): Dimensioned by L4 Employees, includes line items like Term Date, Role, and Department. Module 2 (New Hire Table): Dimension…
Thinking through the results of a modeling decision is a key part of ensuring good model performance; in other words, making sure the calculation engine isn’t overtaxed. This article highlights some i…
Appreciate that it is recommended to avoid using properties in lists, however we do have a couple of instances of this in our model. Just looking to pull one of these into a module that we have alread…
I am at the point where I am comparing my INV01 data to the Anaplan lesson example and my numbers aren't matching. I have a couple of questions about INV01. For Beginning Inventory: My numbers are goo…
As winter is now behind us and the annual process of “spring cleaning” begins, I find that it is a good reminder to not only clean and organize my house, but also to clean another area that most likel…
Hi Team, I would like to get the next year summary value into previous year’s month. If we need current year summary, then we can use YEARVALUE function to achieve but we need to bring data from next …
Hello Everyone, Want to create module which captures data days wise, but the challenge is the data should be Displayed in two ways. So, If current forecast day is 6th Aug, so 1st Column named "Till Da…
Author: Jessie Zhao is a Solution Architect and Certified Master Anaplanner at Anaplan. Working with a model in ALM has a lot of benefits. These include building new features in a development model an…
I have been stuck on this activity for the past 2 days and do not know what I am doing wrong: This is the formula I tried for Bonus: For bonus: IF Employed? THEN Salary * 'EMP03 Employee Drivers by Ro…
Hello! Welcome to the Model Optimization team's monthly blog post. This is an eight-part series, following the topics we see occurring most frequently in slow customer models. Our aim is to inform and…
Almost any model builder has had to come up with a solution to get the current date in Anaplan. We used to build integrations and use API for that. @JaredDolich posted a great article about using pyth…
When model builders modify a saved view, this breaks existing export actions that use that saved view. The reference to the view is not dynamic. For example, if a model builder adds a new line item to…
Hello, Does anyone know why the waterfall intermediate total is showing up in blue? I'm using a ragged hierarchy. With intermediate totals turned on & colour set to black I want to see the forecast ba…
Author: Marina Ketelslegers is a Certified Master Anaplanner and FP&A expert and independent Anaplan Solution Architect. In this 'How I Built It' tutorial, you'll learn how to create a dynamic and fle…
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 Li…
Currently looking to make use of the feature where can now see the calculation effort entailed in certain line items and I've already been able to eliminate or refine a number of elements in various m…
