Calculation Functions

Is there a way to find the context selector parameter for a page
Question for the tech savy. E.g. The link below is the default URL for the page htps://us1a.app.anaplan.com/a/apps/app/b17cc9fb-23/boards/4d39-ff7302 Now when you send an automated notification from Anaplan for a page, the link includes the default URL above (in orange) followed by values which I'm assuming is for the…
Time Scheduling with Optimizer
A system that allows optimized scheduling of dates / times over a period would be very useful (for example a finite capacity scheduler in production scheduling, rather than a scheduling of a team for maintenance interventions, etc ...) to broaden the functional coverage a supply chain model.
8.6.4 Activity of level 1 : The output numbers are different than the correct solution.
Hi, Could possibly someone help me to solve this problem? The output numbers (1'st Pic) are different than the correct solution. In 2'nd Pic you can see the correct numbers, which must seen at the end of the activity. My set up is shown below. Thank in advance!
SYS14 Create Account>Product, Line Item "Data?" can't refer SYS12 and SYS13
I've create on Data Hub the module SYS14 Create Account>Product and looks like: But I am blocked by Data?(Boolean) filter to determine if ANY data for product SKU under the product * If you are using the Level 2 Data Hub model: reference the SYS12 SKU Details and SYS13 Account SKU filter. * If you downloaded a new Data Hub…
Convert list item to time period
We make a weekly copy of the demand plan to be able to calculate bias and forecast accuracy with 2 weeks lag. In a list we created versions : The last Property "Reporting Week" is formatted as Time Period "Week" The data is copied in a module with this list and the product list on the lowest level as dimensions : How can I…
Level 1 Model Building Exam – Model Building Activity 5 - 2 error messages
Hi Anaplan community, Whilst updating line items: Bonus, Car Costs, Phone Costs, Medical Costs I’m getting 2 types of error message: First error message: Data type mismatch: format other than LIST or DATE being referenced as a relation. I've spent close to 4 hours browsing Anaplan community, hoever I still haven't managed…
Activity 5
I have mapped everything right , but the medical cost for December 2020 is showing 36,800 and that is not the right answer. Can anyone please help me with , where I am making the mistake .
Percentile formula
It would save a lot of time and space to have percentile formulas in Anaplan. Percentiles are very valuable to eliminate extreme values from data sets and improve the accuracy of our forecasting models. Having a percentile formula would address the need for a median formula at the same time. Further below are a few…
Optimizing Models, blueprint Analysis
Hi all, I am beginning my journey as a model builder in a company where one of the first task is to try to optimize the current Anaplan Models, I've followed the instructions given here to try to reduce the cell count in a specific module: Context: * Formula repeated several times in different line items and modules. And…
OEG Best Practice: Blueprint analysis: Model analysis techniques using Excel
What? A model analysis technique using metadata from your Anaplan model imported in to Excel, utilizing purpose-built formulas to identify line items of interest Why? We do this so that we have some extra information with which to arm ourselves when trying to optimize a model. It lets us look at every line item, apply the…
IFS function
One of the most powerful "recent" functions I've used in Excel is IFS(), where a single statement can replace multiple levels of IF THEN ELSE statements. From Microsoft's description: Generally, the syntax for the IFS function is: =IFS(Something is True1, Value if True1,Something is True2,Value if True2,Something is…
Get Min Date
Hi, I want to get min Date. I set Min as Summary. If any source item is blank, Summary shows blank. Is there any way to get min Date?
Disagreegation logic
Hi Guys, I am working on a module. where I should input the L1 then it should go L2 level. if I Enter the L2 then it should distribute L3. I can use the break back . I there any functionality available for this scenario
disaggregation logic
Hi guys I am working on an example we have a hierarchy as per my image: whenever i input the country wise then the country data should disaggregate to state level and also, from the state level to district level and
Summing Values across dimensions
Hello - I have modules dimensionalized by an L3 hierarchy (Co/Dep/Sub) with the line items equaling Accounts that are "collected" through a LIS. Now I want to sum my values into an L4; which is just "L3" and "Account "strung together; but my formula of Sum - Lookup: the "L3" and "Account" attributes (Mapped to the L4) does…
Quarter value of forecast for the Qtr in which switchover occurs
What are the alternative workarounds for this? When getting data from a line item Forecast version for a Quarter in which switchover occurs during the quarter, the QUARTERVALUE or [Lookup: <quarter>] return a value that only includes the Actuals amount for the month before the switchover date. (see screenshot)
11.3.4 Activity: Add Formulas to Profit & Loss Report Module
Hi everyone, it seems that I have made a mistake and I can't quite pin down where it is. Here is my table:
Compounding Growth In Forecast Model
Afternoon, Composing a typical growth forecast. I am having an issue when my raw data ends. (FY23 is the last year). Then once I get into my forecast years, the lag function (and previous function) have nothing to pull from (zero value). LAG(Research Allocation Rate (Original), 1, 0) * (1+Growth Rate). So essentially for…
AND and OR logical operators
In our work we need to frequently use several layers of nested IF THEN ELSE statements. These could be greatly streamlined by introducing IF and OR logical operators to Anaplan. For example: IF A = 1 THEN IF B = 2 THEN TRUE ELSE 0 ELSE 0 could be replaced with IF AND(A = 1, B =2) THEN TRUE. In this context, these operators…
Rank list items based on multiple ranking levels
Hi Anaplan users, I am trying to rank PO values by cost center & cost element & period & vendor & PO value. See screenshot and blueprint view attached to follow my reasoning below: I first want to show all POs from the vendor with the highest PO value at vendor & cost center & cost element & period level. That is what I…
Hide certain list member in dropdown
Hi, Is there a way to restrict user access in certain list but they should still see the amount when being aggregated at total list. I need to restrict user to all modules so using the picklist would be little tricky as I need to update everything. Thanks in advance for helping. Tom
Ratio of each accounts product sales by country's previous year actual sales by Prod Family
Hello, This question is related to user story 1.3 and 1.4 We want revenue for each account by product. Further we want to take its ratio against country’s previous years actual sales revenue by product family. Are we looking at a module with dimensions of Country, Product Family , Account & Time (Quarter) to calculate the…
3.3.5.3 check your work
Need some help please, as per example, Safety stock target line item is blank In my module have got summary values here, any pointers please?
stuckon level 1 exam question 7
hello can you help me please i don't understand why i have 0
L2 Sprint 3.3.5.3
Good day I am working through sprint 3 at the moment and all is going well. However in activity 3.3.5.3 INV01 Inventory Ordering "Check your work" I have noticed that my amounts are slightly off when compared to the screenshots. (usually by a factor of 2). Can anyone help and explain why this might be and how I may correct…
Average for a Period of Time for Next Period
Hi Team, I am trying to calculate the "Average" for a Expense for the Period of "FY24". And I want to calculate using the Average from Q3 FY22 to Q2 FY23. On the "actual line items are the expenses for prior quarters and on "RunRate Line Item" I want to calculate the Average for those 4 prior quarters. I am try TIME SUM…
How to make a line item a Subsidiary view
Hi, I'm having trouble making this specific line item in a module into a subsidiary view, in picture attached. The line item i want to make a subsidiary view is Territory. Can i please get some help? Thanks! Amanda
Level 2 Sprint3
Hi, At the end of Sprint 3 there is one lesson which says to Create Product Supply Manager Role so can anyone please help me how to do this lesson and what to do in this.
In L1 Model Building activity 5, There is an error when updating the Bonus formula in EMP02.
Hi, Can someone help me where am I going wrong. As the error is data type mismatch. Please find below screenshot. Thanks in Advance.
Add DCA to INV01 Inventory Ordering- L2 sprint 3
Hi, I am facing doubts in Add DCA to INV01 Inventory Ordering module in L2 Sprint 3 so can anyone please help me how to create DCA formula. It would be great if anyone can help me with this, attaching the course screenshot and the module that I have created according to my understanding.

Calculation Functions

Discussion List