Formula4
- Create a new formula called Formula4.
- Type the following in the Formula text box of the Formula Editor:
If ToText({customer.CUSTOMER ID}) [1] = "5"
"TRUE"
Else
"FALSE"
-
Click Check to test for errors. You will receive the following error message:
The word 'then' is missing.
- Correct the formula by typing in the word "Then" at the end of the first line after "5".
- Click Check again. The formula should now be error-free.
- Place the formula to the right of the @Formula3 field.
-
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-free and the field values returned are correct, you will create a formula that links the separate components together. You will begin by linking the first two formulas (@Formula1 and @Formula2) and then you will add @Formula3 and @Formula4 to create the final formula @FinalFormula.