Hey yall! Happy New Year!

I need a bit of help with a form I am developing.

So...I am collecting a number of answers...all numbers.

e.g Village Population

e.g Number of Boys

e.g Number of Girls

e.g Number of Men

e.g Number of women

I have some indicators and based on the figures entered above for the

various questions. I need to produce an automated score.

To get the score, there is a range e.g 1) 0 to 5 2) 6 - 10 3)11 to 15 ...

what I want happen is as the numbers for the total boys, total girls, total

men, total women is entered I would like to automatically determine the

score....

E.g

I have

village_pop = 20

boys = 10

so [village_pop] div [boys] = 2

score should be automatically be 1 as (2 falls between the range of 0 - 5)

How can I do that

Thanks

Hope I did not confused the hell out of everyone

## ···

--

"Like a camera I use the negative to develop..uDig"

"Success is the ability to go from one failure to another with no loss of

enthusiasm"

---------------------------------------------------------------------------------------------------------->

ᐧ

Hi Roxroy,

You can try the marvellous if() function. This takes 3 parameters

- condition
- value if true
- value if false

You can nest these so for example:

if(${b_ratio} = '0', 'invalid', if(${b_ratio} < 6, 1, if(${b_ratio} < 11,

2, 3)))

I put together a sample form on google drive which is my attempt at

solving your issue.

regards

Neil

## ···

On Wed, Jan 6, 2016 at 3:17 PM, Roxroy Bollers wrote:
Hey yall! Happy New Year!

I need a bit of help with a form I am developing.

So...I am collecting a number of answers...all numbers.

e.g Village Population

e.g Number of Boys

e.g Number of Girls

e.g Number of Men

e.g Number of women

I have some indicators and based on the figures entered above for the

various questions. I need to produce an automated score.

To get the score, there is a range e.g 1) 0 to 5 2) 6 - 10 3)11 to 15 ...

what I want happen is as the numbers for the total boys, total girls, total

men, total women is entered I would like to automatically determine the

score....

E.g

I have

village_pop = 20

boys = 10

so [village_pop] div [boys] = 2

score should be automatically be 1 as (2 falls between the range of 0 - 5)

How can I do that

## Thanks

Hope I did not confused the hell out of everyone

"Like a camera I use the negative to develop..uDig"

"Success is the ability to go from one failure to another with no loss of

enthusiasm"

---------------------------------------------------------------------------------------------------------->

ᐧ

## --

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.

--

Smap Consulting http://smap.com.au/| Mobile Data Collection Solutions

Application Developer - neilpenman@gmail.com minqiang.huang@gmail.com

Twitter: @dgmsot

Skype: ianaf4you

Phone: +61 402 975 959

Website: http://smap.com.au http://smap.com.au/blog

Thanks Neil!

I will give that a go and see.

Rox.

## ···

ᐧ
On 6 January 2016 at 00:32, Neil Penman neilpenman@gmail.com wrote:

Hi Roxroy,

You can try the marvellous if() function. This takes 3 parameters

- condition
- value if true
- value if false

You can nest these so for example:

if(${b_ratio} = '0', 'invalid', if(${b_ratio} < 6, 1, if(${b_ratio} < 11,

2, 3)))

I put together a sample form on google drive which is my attempt at

solving your issue.

https://drive.google.com/file/d/0B5_SmpWlQYxvUlhQY0lFSUxzTG8/view?usp=sharing

regards

Neil

On Wed, Jan 6, 2016 at 3:17 PM, Roxroy Bollers rkbollers@gmail.com wrote:

Hey yall! Happy New Year!

I need a bit of help with a form I am developing.

So...I am collecting a number of answers...all numbers.

e.g Village Population

e.g Number of Boys

e.g Number of Girls

e.g Number of Men

e.g Number of women

I have some indicators and based on the figures entered above for the

various questions. I need to produce an automated score.

To get the score, there is a range e.g 1) 0 to 5 2) 6 - 10 3)11 to 15 ...

what I want happen is as the numbers for the total boys, total girls, total

men, total women is entered I would like to automatically determine the

score....

E.g

I have

village_pop = 20

boys = 10

so [village_pop] div [boys] = 2

score should be automatically be 1 as (2 falls between the range of 0 - 5)

How can I do that

## Thanks

Hope I did not confused the hell out of everyone

"Like a camera I use the negative to develop..uDig"

"Success is the ability to go from one failure to another with no loss of

enthusiasm"

---------------------------------------------------------------------------------------------------------->

ᐧ

## --

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.

--

Smap Consulting http://smap.com.au/| Mobile Data Collection Solutions

Application Developer - neilpenman@gmail.com minqiang.huang@gmail.com

Twitter: @dgmsot

Skype: ianaf4you

Phone: +61 402 975 959

Website: http://smap.com.au http://smap.com.au/blog

## --

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.

--

"Like a camera I use the negative to develop..uDig"

"Success is the ability to go from one failure to another with no loss of

enthusiasm"

---------------------------------------------------------------------------------------------------------->