Difference between revisions of "Formula Builder"
From AgileApps Support Wiki
imported>Aeric |
imported>Aeric |
||
| Line 12: | Line 12: | ||
# The '''[Check Syntax]''' button was clicked, to ensure validity. | # The '''[Check Syntax]''' button was clicked, to ensure validity. | ||
{{Note|<br>When comparing to strings, | {{Note|<br>When comparing to strings, use double quotes:<br/> <tt><nowiki>related_to_Customer.name = "ABC Co."</nowiki></tt>}} | ||
===How it Works=== | ===How it Works=== | ||
#{{:ExpressionBuilder}} | #{{:ExpressionBuilder}} | ||
Revision as of 19:10, 25 July 2011
The Formula Builder lets you interactively define a Formula Expression.
Example
To build that formula:
- The "Order Amount" field was chosen, inserting order_amount
- The Operator "* Multiply" was chosen, inserting *
- The "Related to Customer" field "Discount" was chosen, inserting related_to_Customer.discount
- The entire expression was enclosed in single quotes
- The [Check Syntax] button was clicked, to ensure validity.
Note:
When comparing to strings, use double quotes:
related_to_Customer.name = "ABC Co."
