Difference between revisions of "Formula Builder"

From AgileApps Support Wiki
imported>Aeric
imported>Aeric
Line 1: Line 1:
The Formula Builder lets you interactively define a [[Formula Expressions|Formula Expression]].  
The Formula Builder lets you interactively define a [[Formula Expressions|Formula Expression]].  
__TOC__
__TOC__
===How it Works===
#{{:ExpressionBuilder}}
===Example===
===Example===


Line 16: Line 13:


{{Note|When comparing to strings, include the string in double quotes.<br> E.g. <tt>.name = "ABC Co."}}
{{Note|When comparing to strings, include the string in double quotes.<br> E.g. <tt>.name = "ABC Co."}}
===How it Works===
#{{:ExpressionBuilder}}

Revision as of 19:04, 25 July 2011

The Formula Builder lets you interactively define a Formula Expression.

Example

FormulaBuilder.png

To build that formula:

  1. The "Order Amount" field was chosen, inserting order_amount
  2. The Operator "* Multiply" was chosen, inserting *
  3. The "Related to Customer" field "Discount" was chosen, inserting related_to_Customer.discount
  4. The entire expression was enclosed in single quotes
  5. The [Check Syntax] button was clicked, to ensure validity.

Notepad.png

Note: {{{1}}}

How it Works

  1. ExpressionBuilder