Hi all?

Can anyone help me on this.

I have a formula that sums up the choices selected using:

int(${relev_fpage_1stcard}) + int(${relev_fpage_2ndcard}) +

int(${relev_fpage_3rdcard}) + int(${relev_fpage_4thcard}) +

int(${relev_fpage_5thcard}) + int(${relev_fpage_6thcard}) +

int(${relev_fpage_7thcard}) + int(${relev_fpage_8thcard}) +

int(${relev_fpage_9thcard}) + int(${relev_fpage_10thcard})

The choice list is a single select with; Yes=1, No=0, N/A= -9. The above

formula works well if the choice only had Yes and No.

So I looked around and found:

if(${relev_fpage_1stcard} > 0, int(${relev_fpage_1stcard}, 0) +

if(${relev_fpage_2ndcard} > 0, int(${relev_fpage_2ndcard}, 0) +

if(${relev_fpage_3rdcard} > 0, int(${relev_fpage_3rdcard}, 0) +

if(${relev_fpage_4thcard} > 0, int(${relev_fpage_4thcard}, 0) +

if(${relev_fpage_5thcard} > 0, int(${relev_fpage_5thcard}, 0) +

if(${relev_fpage_6thcard} > 0, int(${relev_fpage_6thcard}, 0) +

if(${relev_fpage_7thcard} > 0, int(${relev_fpage_7thcard}, 0) +

if(${relev_fpage_8thcard} > 0, int(${relev_fpage_9thcard}, 0) +

if(${relev_fpage_10thcard} > 0, int(${relev_fpage_10thcard}, 0)

This is supposed to ignore -9 in the calculation. However it doesnt work.

On the tablet I get the following message;

Invalid caluculate for the bind attacged to

"/RDQATOOL_2016/relevance_fp_sum" : mismatched brackets or parenthesis in

expression,.....

Any assistance to this and my previous post will be highly appreciated.

Thank you in advance.

Louis...

all of your int(...) expressions are missing the trailing ).

Should be int(${...})

## ···

On Tue, Apr 26, 2016 at 9:33 PM, Louis Omoya wrote:
Hi all?

Can anyone help me on this.

I have a formula that sums up the choices selected using:

int(${relev_fpage_1stcard}) + int(${relev_fpage_2ndcard}) +

int(${relev_fpage_3rdcard}) + int(${relev_fpage_4thcard}) +

int(${relev_fpage_5thcard}) + int(${relev_fpage_6thcard}) +

int(${relev_fpage_7thcard}) + int(${relev_fpage_8thcard}) +

int(${relev_fpage_9thcard}) + int(${relev_fpage_10thcard})

The choice list is a single select with; Yes=1, No=0, N/A= -9. The above

formula works well if the choice only had Yes and No.

So I looked around and found:

if(${relev_fpage_1stcard} > 0, int(${relev_fpage_1stcard}, 0) +

if(${relev_fpage_2ndcard} > 0, int(${relev_fpage_2ndcard}, 0) +

if(${relev_fpage_3rdcard} > 0, int(${relev_fpage_3rdcard}, 0) +

if(${relev_fpage_4thcard} > 0, int(${relev_fpage_4thcard}, 0) +

if(${relev_fpage_5thcard} > 0, int(${relev_fpage_5thcard}, 0) +

if(${relev_fpage_6thcard} > 0, int(${relev_fpage_6thcard}, 0) +

if(${relev_fpage_7thcard} > 0, int(${relev_fpage_7thcard}, 0) +

if(${relev_fpage_8thcard} > 0, int(${relev_fpage_9thcard}, 0) +

if(${relev_fpage_10thcard} > 0, int(${relev_fpage_10thcard}, 0)

This is supposed to ignore -9 in the calculation. However it doesnt work.

On the tablet I get the following message;

Invalid caluculate for the bind attacged to

"/RDQATOOL_2016/relevance_fp_sum" : mismatched brackets or parenthesis in

expression,.....

Any assistance to this and my previous post will be highly appreciated.

Thank you in advance.

Louis...

## --

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.

--

Mitch Sundt

Software Engineer

University of Washington

mitchellsundt@gmail.com

Thank you. I will rectify this

## ···

On 27 Apr 2016 22:13, "Mitch Sundt" wrote:
all of your int(...) expressions are missing the trailing ).

Should be int(${...})

On Tue, Apr 26, 2016 at 9:33 PM, Louis Omoya louisomoya@gmail.com wrote:

Hi all?

Can anyone help me on this.

I have a formula that sums up the choices selected using:

int(${relev_fpage_1stcard}) + int(${relev_fpage_2ndcard}) +

int(${relev_fpage_3rdcard}) + int(${relev_fpage_4thcard}) +

int(${relev_fpage_5thcard}) + int(${relev_fpage_6thcard}) +

int(${relev_fpage_7thcard}) + int(${relev_fpage_8thcard}) +

int(${relev_fpage_9thcard}) + int(${relev_fpage_10thcard})

The choice list is a single select with; Yes=1, No=0, N/A= -9. The above

formula works well if the choice only had Yes and No.

So I looked around and found:

if(${relev_fpage_1stcard} > 0, int(${relev_fpage_1stcard}, 0) +

if(${relev_fpage_2ndcard} > 0, int(${relev_fpage_2ndcard}, 0) +

if(${relev_fpage_3rdcard} > 0, int(${relev_fpage_3rdcard}, 0) +

if(${relev_fpage_4thcard} > 0, int(${relev_fpage_4thcard}, 0) +

if(${relev_fpage_5thcard} > 0, int(${relev_fpage_5thcard}, 0) +

if(${relev_fpage_6thcard} > 0, int(${relev_fpage_6thcard}, 0) +

if(${relev_fpage_7thcard} > 0, int(${relev_fpage_7thcard}, 0) +

if(${relev_fpage_8thcard} > 0, int(${relev_fpage_9thcard}, 0) +

if(${relev_fpage_10thcard} > 0, int(${relev_fpage_10thcard}, 0)

This is supposed to ignore -9 in the calculation. However it doesnt work.

On the tablet I get the following message;

Invalid caluculate for the bind attacged to

"/RDQATOOL_2016/relevance_fp_sum" : mismatched brackets or parenthesis in

expression,.....

Any assistance to this and my previous post will be highly appreciated.

Thank you in advance.

Louis...

## --

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.

--

Mitch Sundt

Software Engineer

University of Washington

mitchellsundt@gmail.com

## --

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.