AnsweredAssumed Answered

Conditional Field Result

Question asked by user17322 on Jun 5, 2012
Latest reply on Jun 5, 2012 by jake

Title

Conditional Field Result

Post

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.

 

Thanks

Outcomes