How to use IF functions as an embedded data field? | XM Community
Solved

How to use IF functions as an embedded data field?

  • 1 October 2018
  • 3 replies
  • 329 views
C
Hi,
I would like to set an embedded data field which takes into account one of the survey participant's previous answers. In Excel, I would create this function:
if(PreviousAnswerX=20, 20, 0). This says that if the participant's answer to question X was 20, the embedded data field should be set to 20. Otherwise, the embedded data field should be 0.

Is there a way to create such a function in Qualtrics?
Thanks so much!
icon

Best answer by PeeyushBansal 1 October 2018, 18:18

View original

3 replies

Akdashboard
Rank
Userlevel 7
Badge +6
In the survey flow, you need to apply branching logic using branching elements (where you put in the question logic you want, like if Q1 = 20), then nest an embedded data element in the branch element.

Easy peasy.
C
Thanks! This is very helpful.
I use this logic quite often and hoped to find a simple, dynamic formula to create a calculated field. This way, I could avoid creating dozens of branches and embedded data fields in the survey flow. But this works well too, thanks again!
PeeyushBansal
Rank
Userlevel 7
Badge +33
Initially set your embedded variable equals to 0 at top of survey flow. Later apply branch logic and set same variable within branching equal to 20
Best Regards, Peeyush

Leave a Reply


Terms & Conditions