Less than or equal to
(This section relates to users with an Enterprise Licence only)
Use the less than or equal to (>=) operator in a formula when you
want to compare two values. The formula evaluates to TRUE when the value
on the left of the operator is less than or equal to the value on the
right. The values can be derived from formulas, database fields, or you
can enter literal values.
To test for less than or equal to:
Syntax:
- In the Formula
pane, from the row of Operator
buttons, click the <= button.
The operator is automatically entered, ready for you to construct
your formula:
<=
- Construct the formula
using the tools provided to add the required parts; Value. For example,
if you wanted to check whether the property purchase price is less
than or equal to £150,000, the formula might look like this:
Matter.PurchasePrice<=150000.00
- (Recommended) Test the formula against a matter
to make sure it produces the expected result. To do this, type a matter
number in Entity Ref/ID and
click Test Formula.
Notes
- This operator only works with
formulas of type Logical.
- Before adding parts to
a formula you must click the insertion point to set focus.
- When testing, if the result
is not as expected then amend the formula and retest.
|