[ODK Community] If statement in XLSFORM not calculating correctly

Hi Miranda,

I didn't look closely at the form, but I bet the problem is that you
aren't using single quotes around yes. It should be:

if( (${Concentration1} < ${Concentration2} and ${Effluent2_skip} =
'yes'), ${Concentration2}, ${Concentration1})

Yaw

··· -- Need ODK services? http://nafundi.com provides form design, server setup, professional support, and software development for ODK.

On Wed, Aug 20, 2014 at 4:38 AM, Miranda Muller psychadelic.flutterby@gmail.com wrote:

Hi there,

I am trying to design a tool that can be used to classify an incident
severity.

I am using the expression - if ((${a} > ${b} and ${c}= yes), ${a}, ${b}) in
xlsform.

However, even when ${a} > ${b} is TRUE and ${c}= yes is TRUE, is still
calculates the value of ${b}.

I'm not sure if my syntax is wrong, or if there is a bug, but I would hugely
appreciate some help! I have attached the xlsform that I am using and
highlighted the troublesome rows in yellow.

Looking forward to everyone's feedback! Thanks in advance! :slight_smile:

Miranda

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.