Frequently Asked Questions
The following is a list of frequently asked questions and answers in regards to the Configurable Formula functionality.
No, Configurable Formulas are only supported on persisted fields defined on the business object.
Can I specify when to trigger the formula?Can I specify when to trigger the formula?
Yes, you can choose an appropriate system event using the Trigger Action options available on the formula record. Advantage will activate the formula when the associated system event is executed.
Yes, Advantage uses a third party library, Apache JEXL, for expression evaluation and syntax must comply with JEXL rules. Please refer to the Formula Expression Syntax topic for additional details.
Yes, there is no limitation. Advantage supports any number of fields (of referenced business object) within the expression including baseline and "added" fields created via extensibility. In addition, Advantage supports simple JAVA style conditional elements to run logic and calculate field value. Please refer to the Formula Expression Syntax topic for additional details.
The system will not allow you to create a Configurable Formula on a field if there is already a formula defined in baseline using Derivation Type Sum, Count, Parent Replicate, or Formula.
Yes, a Configurable Formula can be used to override a field’s default value to meet site requirements.
No. The ability to edit a field is not controlled by Configurable Formula and you need to use other extensibility techniques to make the field read-only.
No. Configurable Formula is applied at the data model level and is integrated into business object processing framework. The formula is evaluated from both online and offline activity.
