Specify Resulting Value for COMPARE Function
It would be helpful if the COMPARE function could be modified to specify different resulting values. Currently, the formula returns 0 if there is a match and -1 or 1 if there is a match. Ideally you could specify any values, but returning 1 if there is a match and 0 if there is not a match would provide a useful alternative to long nested IF formulas.
For example, if you have five different possible drivers you could write a formula like (Driver 1 Value or Line Item * COMPARE + Driver 2 Value or Line Item * COMPARE + Driver 3 Value or Line Item * COMPARE + Driver 4 Value or Line Item * COMPARE + Driver 5 Value or Line Item * COMPARE). The user would pick the driver they want to use and each of the COMPARE functions would test if the driver equaled the selected driver. Only the selected driver would return 1 so the formula would evaluate to the Driver 1 value.
The above can currently be accomplished with (1 - abs(COMPARE)) but it isn't as flexible or clean as allowing the user to specifying the resulting value.
Comments
-
Typo in my original post - should have read "Currently, the formula returns 0 if there is a match and -1 or 1 if there is a not a match"
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