Modeling

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

Community Challenge Recap: Polaris Modeling and Optimization
In this Community recap event, we will cover the most effective techniques for module rebuilding and optimization with the Polaris calculation engine, based on the top solutions from our participants in the latest Polaris Community Challenge.
Managing Hierarchies with Anaplan Data Orchestrator (ADO)
Join Anaplan experts for a practical deep dive into Anaplan Data Orchestrator (ADO) and learn how organizations are using it to streamline hierarchy management and support connected planning at scale. This session is designed for model builders, COE teams, solution architects, IT leads, and other hands-on Anaplan users…
ACE: Anaplan Workflow
Registration and events details will release closer to the event date. Join us for the third session in our Workflow Expanded series as part of the Anaplan Community Experience program. This session continues our exploration of Workflow best practices and builds on the lessons from the earlier events in the series. We will…
ACE: Anaplan Workflow
Registration and events details will release closer to the event date. Join us for the fourth session in our Workflow Expanded series as part of the Anaplan Community Experience program. In this session, we continue building on the concepts and best practices discussed throughout the series, with a focus on helping model…