Forum Discussion

AmptivaInc's avatar
AmptivaInc
Qrew Cadet
6 years ago

Help with an IF statement when using two fields

I have two different fields that I would prefer to combine into one so I can use it as a default filter more easily.  I am struggling to get it to work and could use some advise.  Here is the basic fo...
Formulas and functions
AmptivaInc's avatar
AmptivaInc
Qrew Cadet
6 years ago
If the user answers only one or the other then it would display:

Q1 only -- would only display Question 1 answered 
Q2 only -- would only display Question 2 answered

If neither question answered it should be excluded.
If both questions answered, it is already covered by the above when both options are selected in the report.  Does this make sense?