Difference between revisions of "Formula Builder"

Revision as of 19:04, 25 July 2011

The Formula Builder lets you interactively define a Formula Expression.

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, include the string in double quotes.
E.g. .name = "ABC Co."}}

@@ Line 9: / Line 9: @@
 To build that formula:
-# The User Field "Role" was chosen, inserting <tt>user.primaryteamrolename</tt>
+# The "Order Amount" field was chosen, inserting <tt>order_amount</tt>
-# The Operator "not equal" was chosen, inserting <tt>!=</tt>
+# The Operator "* Multiply" was chosen, inserting <tt>*</tt>
-# The role name was typed in, enclosed in double quotes: <tt>"Director"</tt>
+# The "Related to Customer" field "Discount" was chosen, inserting <tt>related_to_Customer.discount</tt>
-# The entire expression was surrounded in single quotes: <tt>'...'</tt>
+# The entire expression was enclosed in single quotes
 # The '''[Check Syntax]''' button was clicked, to ensure validity.
+{{Note: When comparing to strings, include the string in double quotes.<br> E.g. <tt>.name = "ABC Co."}}