Screen out participants based on BMI | XM Community
Skip to main content
Solved

Screen out participants based on BMI

  • October 18, 2018
  • 17 replies
  • 141 views

Hi, I also want to screen out respondents that have a BMI of <= 25. Somehow it doesn't work, if I use the preview I always continue the survey whether my answers end up in BMI <= 25 or not. So none of the responses are screened out. The height and weight items are: Text entry single-line (content validation -number) I have attached the questions, survey flow and data analysis formula. I would be grateful for any help! 11:40AM

Best answer by PeeyushBansal

add "e" at beginnning after $

17 replies

PeeyushBansal
Level 6 ●●●●●●
Forum|alt.badge.img+43
  • Level 6 ●●●●●●
  • October 18, 2018
check wether BMI is storing correct value. Check with data on basis of your inputted value.

PeeyushBansal
Level 6 ●●●●●●
Forum|alt.badge.img+43
  • Level 6 ●●●●●●
  • October 18, 2018
Also seems like you are storing result in BMI Number and in branch using only BMI.

  • Author
  • October 18, 2018
Thanks!! I will look into that and will get back to you! Loes

  • Author
  • October 18, 2018
Ok. So BMI is storing correct data (input weight 40, height 160) see attachment. However, there seems to be another BMI (empty) which I can not delete? "Number" behind I added with option and when I write BMB Number in the branch it does not help unfortunately. Maybe there is another issue? Loes

PeeyushBansal
Level 6 ●●●●●●
Forum|alt.badge.img+43
  • Level 6 ●●●●●●
  • October 18, 2018
Oh that's a problem rename this variable to some other name say BMI_calculated

  • Author
  • October 18, 2018
So, I started from scratch to make a clean start. However it still does not work. I hope it can be solved!

PeeyushBansal
Level 6 ●●●●●●
Forum|alt.badge.img+43
  • Level 6 ●●●●●●
  • October 18, 2018
In image instead of "(" 9 is appearing at beginning can u check.

  • Author
  • October 18, 2018
Ah, yes that was a typo. I removed it but still a problem.

  • Author
  • October 18, 2018
Do I need to do something specific to the settings of "End of Survey"?

PeeyushBansal
Level 6 ●●●●●●
Forum|alt.badge.img+43
  • Level 6 ●●●●●●
  • October 18, 2018
Survey flow seems correct, are you still able to see two variables for BMI in data or a single variable.

PeeyushBansal
Level 6 ●●●●●●
Forum|alt.badge.img+43
  • Level 6 ●●●●●●
  • October 18, 2018
Can u share qsf file

  • Author
  • October 18, 2018
Thank you for helping! Here is the file.

  • October 18, 2018
Hello @Loes , BMI formula is BMI= weight / (Height)*(Height) Your Math operation should be: `$e{ ( q://QID2/ChoiceTextEntryValue ) / ( ( q://QID1/ChoiceTextEntryValue ) * ( q://QID1/ChoiceTextEntryValue ) ) }` Image: ! Updated QSF attached

  • Author
  • October 18, 2018
Hi Shashi, thank you. I used (height/100)*(height/100) because I want to ask respondents to enter their height in centimeters eventually.

  • October 18, 2018
> @Loes said: > Hi Shashi, > thank you. > I used (height/100)*(height/100) because I want to ask respondents to enter their height in centimeters eventually. > > Updated Math formula `$e{ ( q://QID2/ChoiceTextEntryValue ) / ( ( ( q://QID1/ChoiceTextEntryValue ) / 100 ) * ( ( q://QID1/ChoiceTextEntryValue ) / 100 ) ) }`

PeeyushBansal
Level 6 ●●●●●●
Forum|alt.badge.img+43
  • Level 6 ●●●●●●
  • Answer
  • October 18, 2018
add "e" at beginnning after $

  • Author
  • October 18, 2018
YES! Thank you so much, I added your formula and now it works! Indeed with the "e" That's great! Thank you both for thinking along with me!