Screen out participants based on BMI | XM Community
Solved

Screen out participants based on BMI

L
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
icon

Best answer by PeeyushBansal 18 October 2018, 15:31

View original

17 replies

L
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!
PeeyushBansal
Rank
Userlevel 7
Badge +33
add "e" at beginnning after $
Best Regards, Peeyush
A
> @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 ) ) }`
L
Hi Shashi,
thank you.
I used (height/100)*(height/100) because I want to ask respondents to enter their height in centimeters eventually.
A
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
L
Thank you for helping! Here is the file.
PeeyushBansal
Rank
Userlevel 7
Badge +33
Can u share qsf file
Best Regards, Peeyush
PeeyushBansal
Rank
Userlevel 7
Badge +33
Survey flow seems correct, are you still able to see two variables for BMI in data or a single variable.
Best Regards, Peeyush
L
Do I need to do something specific to the settings of "End of Survey"?
L
Ah, yes that was a typo. I removed it but still a problem.
PeeyushBansal
Rank
Userlevel 7
Badge +33
In image instead of "(" 9 is appearing at beginning can u check.
Best Regards, Peeyush
L
So, I started from scratch to make a clean start.
However it still does not work.

I hope it can be solved!
PeeyushBansal
Rank
Userlevel 7
Badge +33
Oh that's a problem rename this variable to some other name say BMI_calculated
Best Regards, Peeyush
L
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
L
Thanks!!
I will look into that and will get back to you!

Loes
PeeyushBansal
Rank
Userlevel 7
Badge +33
Also seems like you are storing result in BMI Number and in branch using only BMI.
Best Regards, Peeyush
PeeyushBansal
Rank
Userlevel 7
Badge +33
check wether BMI is storing correct value. Check with data on basis of your inputted value.
Best Regards, Peeyush

Leave a Reply


Terms & Conditions