Reply to comment
1. Create a new view or edit an existing one. On your Repot Builder screen, click on "Custom Options" in the "Additional Options" screen. Check the "Define a custom formula column for this view" box to further expand this section.
2. In the "Type" drop-down list, select "Checkbox."
3. In the "Formula" box, enter the following formula:
[Field 1]=[Field 2]
where "Field 1" and "Field 2" are the names of the fields you want to compare. Also, make sure Field 1 and Field 2 are the same field type or convert them to the same field type before doing the comparison.
4. Under the "Filtering" section, select "Only records which meet certain criteria". Then, in the "match records for which the following are true" area, choose <Custom Column> from the "select a field" drop down list. Select "is" in the middle field, and enter "Yes" in the text box.
- 34429 reads
