Breaking apart SUM/LOOKUP
Options
aferguson
Member, ALL USERS, Partner Posts: 5 New Contributor
Hello all,
My team is working on breaking apart a particularly complicated SUM/LOOKUP formula that was built 4 years ago. Looking for guidance anyone may have out there. Here's what the scenario is:
- 5 SUMs & 2 LOOKUPs in same formula
- 2 of the 5 SUMs & the 2 LOOKUPs are traditional SUM/LOOKUP combos (so the dimensions are not in the source or target modules)
- Time is one of the dimensions SUMming on
Looking to break apart as much as possible in order to attain largest performance gain. We have hyper model, space should not be an issue.
Many thanks in advance!
Tagged:
0
Categories
- All Categories
- 2.3K Anaplan Community
- Academy
- Anaplan Talent Builder
- Model Design Course
- The Anaplan Way
- Archive
- 2 Idea exchange
- 62 Enterprise Scale
- 1.1K Extensibility
- 21 Intelligence
- 1.6K Planning & Modeling
- 331 Security
- Community Connections
- Connections
- Experiences
- Groups
- Personas
- Employees
- CS Toolkit
- Customer Care Center
- Forums
- Academy & Training
- Community Feedback & Updates
- Japan
- Anaplan Community Japan
- Anaplan Community Japan Knowledge Base
- HyperCare Japan
- JP-Central
- Support-Japanese
- Partners
- Partner Leadership Council
- Partner Product Council
- 724 Platform
- Anapedia
- App Hub
- Centers Of Excellence
- Extensions
- Planual
- Platform Updates
- 724 User Experience
- Profile Builder
- Resources
- Anaplan Advocates
- Anaplan Live!
- Community
- Community Advancement
- Community Connections
- Partner Program
- The Official Master Anaplanner Program
- Videos
- Welcome to the Anaplan Community!
- Success Central
- Support
- Case Portal Link
- Common Support Questions
- HyperCare Redirect
- Known Issues and Workarounds
- Support test page
- SupportFAQ
- Survey
- 2 Training Day Takeaways