Since you are using two fields that apparently store either yes or no, you have 4 possible combinations of values:
Field1 = yes, Field A = no
field 1 = yes, field A = yes
field 1 = no, field A = no
field 1 = no, field A = yes
What would the report look like for each of these possible combinations?
Try using the case statement
That looks like it will work. Where do I find that option? Not sure how to get that logic into the report. Pardon my lack of programming skill.
if you go to fm help it shows you a few examples, try this in a calculation field.
Case(field1 = "Yes";"yes"; field2 = "no";"no"; field2 = "yes";"yes";
"If no statments are true - past your default here")
//keep using this formula field to query = "if result is";"answer";
// make sure to have the calculation result as text