#### 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"

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

`The matching ' for this string is missing.`

1. Correct the formula by changing the single quote (') before Ro to a double quote (").
2. Click Check again. The formula should now be error-free.
3. Place the formula to the right of the @Formula2 field.
4. 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".

Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com