1 Reply Latest reply on Nov 5, 2018 12:29 AM by Cédric Tran

# Combining results from two either/or questions

Hello everybody,

I have extracted the results from a survey. There are two exact questions like "Are you aware/have..".

Only one of these questions was shown to a respondent, depending on a previous answer.

Thus, if there is a null value for one of the two questions, there will be a non-null value in the other of the questions.

I thought I could solve it with this formula:

If([Are you aware/have you heard of scams or sudden closures (bankruptcy) of merchants within the beauty and wellness industry? 11]=null) Then [Are you aware/have you heard of scams or sudden closures (bankruptcy) of merchants within the beauty and wellness industry?1] ELSE [Are you aware/have you heard of scams or sudden closures (bankruptcy) of merchants within the beauty and wellness industry? 11] END

However, this still did not yield the desired result. There should not be any null values in the end

Thank you very much for your help!!

Best wishes

• ###### 1. Re: Combining results from two either/or questions

Hi,

Could you try this ?

IF CONTAINS([Are you aware/have you heard of scams or sudden closures (bankruptcy) of merchants within the beauty and wellness industry? 11], 'Yes') THEN 'Yes'

ELSEIF CONTAINS([Are you aware/have you heard of scams or sudden closures (bankruptcy) of merchants within the beauty and wellness industry? 11], 'No') then 'No'

ELSEIF CONTAINS([Are you aware/have you heard of scams or sudden closures (bankruptcy) of merchants within the beauty and wellness industry?1], 'Yes') then 'Yes'

ELSEIF CONTAINS([Are you aware/have you heard of scams or sudden closures (bankruptcy) of merchants within the beauty and wellness industry?1], 'No') then 'No'

end

Cedric