Data validation criteria messed up by "999"

Hi,
You may have to introduce an intermediate variable (dummy to account for 999 in Q2 i.e. ${slept_pregnant} create a dummy calculate question

${dummy_slept_pregnant} which is equal to
if(${slept_pregnant}=999,0,${slept_pregnant})

Then use the dummy in the calculation instead

(.<=${slept_people} and . <= (${slept_people}-${dummy_slept_pregnant})) or (.=999)

1 Like