Formula3

1. Create a new formula called Formula3.
2. Type the following in the Formula text box of the Formula Editor:

If {customer.CUSTOMER NAME} [1 to 2] = 'Ro" Then
    "TRUE"
Else
    "FALSE"

3. Click Check to test for errors. You will receive the following error message:

The matching ' for this string is missing.

4. Correct the formula by changing the single quote (') before Ro to a double quote (").
5. Click Check again. The formula should now be error-free.
6. Place the formula to the right of the @Formula2 field.
7. Click Print Preview on the Standard toolbar to see the values in the report and compare the fields to check if the field values returned by @Formula3 are correct.

You should see "TRUE" next to all Customer names that begin with "Ro" and "FALSE" next to all Customer names that do not begin with "Ro".