Calculation Functions
Discussion List
-
Replicate the Today() Function in Anaplan
Author: Robin Drinkall is a Certified Master Anaplanner with 9 years' experience in the finance industry. Today() is an extremely useful function within spreadsheet / database applications that will return the current system date. This function is used very commonly seen and used extensively with general functions…
-
How I Built It: Circular references
Author: Andrew Tye is a Certified Master Anaplanner and Technical Lead at Aviva. In this 'How I Built It' video I go through the steps I followed to resolve a circular reference issue in a time series cash-flow module using LAG and strict. Often in modeling you're trying to achieve something that is easy to achieve within…
-
Build Anaplan Line Items by Just Asking Claude. But What Happens to Your Data?
I asked Claude to add line items and a formula to a planning model in Anaplan, and it did the job in a few minutes from plain sentences. No special add-on, no clicking through menus myself. That is exciting, and it raises the question every team should ask first: what happens to our data? The short answer is that it…
-
Create a Boolean-formatted line item to select the first week of the timescale (Year)
Hi everybody! Can someone help me with this simple excercise from level 2 please. I need to create a boolean line item that flags the first week of the time range (Year). Thanks in advance!
-
How to use the SUM function
Summary: When building Anaplan models, the SUM function is used to add up values that meet one or more specific criteria. Find out how to construct a formula using the SUM function in this short lesson. Course Objectives: By the end of this lesson, you’ll be able to: * Identify source and mapping cross reference data to…
-
Level 2 Sprint 3 - Safety Stock Flag Count
Season's greetings all. I don't know why I am wrestling with this formula as it seems straight forward but it does not appear to be working correctly. My line item formula is as follows; 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Country Made In] Is there a logic context error here…
-
Ratio Summary method against two dimensions
Has anyone tried using Ratio Summary against two dimensions in Classic? I have managed to get it working on Polaris before but for some reason doesn't want to do it in Classic
-
Change a summary calc
I am creating a balance sheeting planning in Anaplan with a list below. For "Net Assets" line, how do I make it "Assets" - "Liabilities" instead of sum of assets and liabilities
-
Applying Formulas to Specific Rows in a Flat List While Keeping Line Items as Columns
This question may have been asked and answered before, but I’d appreciate your thoughts on the following scenario. If a Flat List is used as the rows in a module, is it possible to apply formulas to specific rows within that list? In the example below, Revenue and COGS are pulled from a DAT module by using a SYS module…
-
Anaplan P&L Design: Should I Use a Flat List for P&L Rows and Line Items for Reporting Columns?
Hi everyone, couple questions here: I’m building an Actual vs. Budget P&L reporting model in Anaplan and would appreciate advice on the best structural approach. I’ve attached a screenshot of the desired layout. The report needs P&L items as rows, and the following as columns (line items): Actual Budget Variance $ Actual %…
-
Retention of Anaplan Native Time Data If It Is Present in the Model Calendar Range even on changing
I have a model calendar with current year set to FY27 which runs from Apr-26 to Mar-27 with one previous year and one future year i.e. FY26 (Apr-25 to Mar-26) and FY28 (Apr-27 to Mar-28). I have setup a current year time range with 1 year with Apr-26 to Mar-27. Now when I change the model calendar FY setting to start from…
-
How can I calculate % of Revenue dynamically for each P&L line item in an Anaplan reporting module?
Hi everyone, I'm building an Actual vs. Budget P&L reporting module in Anaplan using a Line Item Subset (LIS) to display the P&L items. I would like to extend my report to include three additional columns under a "% of Revenue" section: Act % = Actual amount / Actual Revenue Bud % = Budget amount / Budget Revenue % Var =…
-
How should I structure a Line Item Subset (LIS) module to display Actual, Budget, and Variance
Hi everyone, I'm working on recreating a P&L reporting model in Anaplan and would appreciate some guidance on the best way to structure the underlying modules. In my current setup, I have a Line Item Subset (LIS) containing P&L line items, which I am using in a reporting module to display Actual, Budget, and Variance side…
-
Tell us what your teammates need from your dashboards
As an Anaplan user tasked with helping your teams better understand their data through your Anaplan UX dashboards, we want to hear more about what your end users tell you. What kinds of visualizations are they are asking you for, what do they struggle with in accessing and understanding your data, and how you resolve those…
-
Level 1 Lesson 4.6.9 File Mapping Guide
Hi Everyone My import was successful however it doesn't match the guide Here's the result of my mapping Here's the guide Hope to hear from everyone soon!
-
Create a Formula to Reference a User's Model Role
Dynamic cell access can be extremely challenging with long user lists, especially if you want a user's read/write abilities to be dependent on their model role. If we were able to reference a user's model role via a formula, we could create role specific criteria for dynamic cell access.
-
Anaplan Offset Formula is looking for value outside timeranges
Hi, I'm using the OFFSET formula, where a calculated and number-formatted field determines how many previous weeks the formula should look back. Based on this value, it retrieves the corresponding week's data into the output line item. The formula works correctly for some products; however, it fails for others. The issue…
-
Intermittent Anaplan Interface Error Message
Hello, Former Anaplan Support member here. I was just about to create a Support Ticket for this intermittent error message, I wanted to see if there were others who have run into this message before? 1) I am checking to see if other users are facing this issue. 2) This is not model or workspace specific. I have already…
-
Current Date and Time
It would be great to have a function to get current date and time. Timezone settings could be common for all users and maintained in the settings section
-
Workspace model oversize
Hi, I received an error msg regarding the workspace exceeding the size limit when I wanted to add more lists into “Applies to” as I added an additional context/page selector and needed to add up the figures with an additional criteria in the formula bar using the sum function Is there a way to resolve this issue? Kindly…
-
FCR - Entity alternated hierarchy use
Currently the entity alternate hierachies are not used as they should. Several issues are encountered when using those : Validation reports and Intercompanymatching report can not be filtered using this alternate hierarchy. Whereas it is only a matter of what members you want to see. When using the alternate hierarchy on…
-
Native function for Date & TimeStamp
Hi, is there in Anaplan the possibility to retrieve current time (date and time)? I know that now this is possibile only via integrations, but I will need to know if there is a native function.
-
IS Summary
Hi All, I just wanted to understand the importance of Is summary in Anaplan. I have a module created with Is Summary switched on for a line item in my module which is preventing that line item from coming in the export view taken out by omitting summary items. When I remove the checkbox from is summary for that line item I…
-
Level 1 Model Building Exam Activity 5 - Stuck!
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 Role’.Bonus % [LOOKUP: 'EMP03 Employee Drivers by Role’.Department, LOOKUP: 'EMP03 Employee Drivers by Role’.Role] ELSE 0 And…
-
FCR: Improve input parameters for calculations
When we have to run calculation for a specific entity, it can we very time consuming to select that entity, because we have a rather deep hierarchy for entities. It would be so much more convenient if we can also enter the the name manually. Next, please show the parameters from the prior run. When the prior parameters are…
-
Allow ISFIRSTOCCURRENCE to search against time
IFO returns true for the first occurence of a value against a specific list formatted dimension. i would like the possibility to validate against the time dimension as well.
-
Running IRR (IRR Calculation by Period)
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: The IRR function in Anaplan is calculating the final IRR based on the entire cashflow over the timescale. We need it to calculate it…
-
FCR: run calculations over multiple months
Today we can select within our Date dimension Total Year or Quarter. We would expect that the system with apply the calculation on the related months underneath. But this seems not to be the case. Only when we specify a single month the calculation will be applied. During year-end close we have to adjust certain movements…
-
SUM and LOOKUP | Model Optimization Team series
Hi! 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 guide how to build with best practice intentions for these model building topics. Each month, two of our analysts will take…
-
user filtering to the top of a hierarchy
I am trying to do something that must be very simple but for the life of me i cannot work it out. In this TEST MODULE i have a normal filter and i apply a logic to the sales volume stating if check? (the customer in the module = chosen customer) then sales volume else 0 and it works 100% as expected, removing the values…
Upcoming Events
-
Unlocking the Value of Community with Anaplan Community Bosses
Join us for an exclusive professional development roundtable designed to celebrate, connect, and elevate our premier platform advocates: the Anaplan Community Bosses. The Community Boss program stands at the very heart of our ecosystem, highlighting leaders who dedicate their time to guiding peer model builders and…
-
Designing for Fit, Utility, and Practical Guardrails with AnaplanXL
Join Anaplan experts for a practical introduction to AnaplanXL (AXL), the Excel add-in that connects Excel grids directly to governed Anaplan data. As the first session in our technical series, this event is designed to help: Model Builders understand the fundamental purpose of AXL: what AXL does, the basic guardrails for…