If ToText({customer.CUSTOMER ID}) [1] = "5"
Click Check to test for errors. You will receive the following error message:
The word 'then' is missing.
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 @Formula4 are correct.
You should see "TRUE" next to all Customer IDs that begin with 5 and "FALSE" next to all Customer IDs that do not begin with 5.
Now that the formulas are error
Go on to Formula1+2.
| Seagate Software IMG Holdings, Inc. http://www.seagatesoftware.com Support services: http://support.seagatesoftware.com |