Conditional Field Result
I have a report that is a single line of output for each record. I want to include one of two fields conditioned upon the contents of a third.
As an example:
if Field 1 = Yes the report will look like this:
Field 1 Field 2 Field 3 Field 4
If Field A = No the report will look like this
Field 1 Field 2 Field 3 Field 5
There are both yes's and no's in the records for the report.
Let me know if there is logic I can use to accomplish this.