Calculation Functions

Line item reference
I have a currency module containing Line Items, Time and Version with the line items as currency codes and the values as exchange rates. This has Line items as rows, Time as columns and Version as a page. I have a details module that contains amounts in local currency and a currency indicator. In another module I want to…
How do I sum across dimensions other than time?
Can't see how this was done in the allocations video. I have a list for products, and a line item for sales. I want to introduce a line item that returns the total sales for all products against every product. Beyond allocation use, is there a way to introduce a line item that returns the value at the next level up a…
How to use a drop-down list within the PROFILE function
Hi - struggling to get my head around this. Not sure if I'm getting the syntax wrong, or whether what I'm trying to do simply isn't possible. I want the model user to be able to make a selection in a drop-down list from a number of different allocation profiles to use in the PROFILE function. To hold the different…
Create Subtotal of Existing Line Items
How do I make an existing line item a subtotal of other line items? Line items below: - Opening Stock - Purchases - Issue of Stock - Closing Stock Formula should be: Opening Stock + Purchases + Issue of Stock = Closing Stock

Line item reference
I have a currency module containing Line Items, Time and Version with the line items as currency codes and the values as exchange rates. This has Line items as rows, Time as columns and Version as a page. I have a details module that contains amounts in local currency and a currency indicator. In another module I want to…
How do I sum across dimensions other than time?
Can't see how this was done in the allocations video. I have a list for products, and a line item for sales. I want to introduce a line item that returns the total sales for all products against every product. Beyond allocation use, is there a way to introduce a line item that returns the value at the next level up a…
How to use a drop-down list within the PROFILE function
Hi - struggling to get my head around this. Not sure if I'm getting the syntax wrong, or whether what I'm trying to do simply isn't possible. I want the model user to be able to make a selection in a drop-down list from a number of different allocation profiles to use in the PROFILE function. To hold the different…
Create Subtotal of Existing Line Items
How do I make an existing line item a subtotal of other line items? Line items below: - Opening Stock - Purchases - Issue of Stock - Closing Stock Formula should be: Opening Stock + Purchases + Issue of Stock = Closing Stock

Upcoming Events

Streamlining business processes with Workflow
Join Anaplan experts for a practical deep dive into how Anaplan Workflow helps organizations streamline business processes, eliminate operational bottlenecks, and automate planning approvals at scale. This session will explore how structured workflows direct stakeholders to the right task at the right time, helping…
Community Challenge Recap: Enhanced board layouts
Join us for our Community Challenge Recap where we'll dive into the creative and innovative ways members are using the enhanced board layout features. Our guest host, Anaplan's Platform Adoption Specialist, Seb McMillan, will showcase the best submissions from September’s Community UX Challenge. This is your opportunity to…
User Experience Design Thinking
The quality of the User Experience is crucial for the successful deployment of your Anaplan applications Whether designing a new application or re-imagining an existing one, the approach you take can make the difference between an OK experience for your users and a great one. Join Anaplan experts for a deep dive into how…
Anaplan Quarterly Customer Platform Release
Anaplan's next quarterly platform release webinar will be held October 28, 2026 at 8:00 a.m. Pacific Time. During this session, we will explore the latest features so you can optimize your Anaplan experience! Our expert-led session will equip you with live demonstrations to help you get the most out of new features and…

Streamlining business processes with Workflow
Join Anaplan experts for a practical deep dive into how Anaplan Workflow helps organizations streamline business processes, eliminate operational bottlenecks, and automate planning approvals at scale. This session will explore how structured workflows direct stakeholders to the right task at the right time, helping…
Community Challenge Recap: Enhanced board layouts
Join us for our Community Challenge Recap where we'll dive into the creative and innovative ways members are using the enhanced board layout features. Our guest host, Anaplan's Platform Adoption Specialist, Seb McMillan, will showcase the best submissions from September’s Community UX Challenge. This is your opportunity to…
User Experience Design Thinking
The quality of the User Experience is crucial for the successful deployment of your Anaplan applications Whether designing a new application or re-imagining an existing one, the approach you take can make the difference between an OK experience for your users and a great one. Join Anaplan experts for a deep dive into how…
Anaplan Quarterly Customer Platform Release
Anaplan's next quarterly platform release webinar will be held October 28, 2026 at 8:00 a.m. Pacific Time. During this session, we will explore the latest features so you can optimize your Anaplan experience! Our expert-led session will equip you with live demonstrations to help you get the most out of new features and…