Newbie Questions

Re: Summing up of multiple drop-down values

adrianodl — Mon, 24 Sep 2012 23:44:16 GMT

Hi Gennady,

That's right, the field does not support multiple parameters. I actually got it working by doing the simplest thing: field1 + field2 + field3...

Easy!

Thanks for your help,

Adriano

Re: Summing up of multiple drop-down values

Gennady Vanin (Геннадий Ванин, Новосибирск) — Thu, 20 Sep 2012 06:53:11 GMT

adrianodl:
the sum(field1, field2, field3)

The description of a sum() function (when inserting it) tells that it has no more than one argument :

sum(field)
Returns the sum of all fields in a field or group.
Each field is first converted tto a number value

It would have been strange to have a function that would have required to write many (compare sum(f1, f2) with f1+f2 BLOCKED EXPRESSION

Though I failed to get any sane results after applying it to group of Dropdown List Boxes as sum(Group), where Group contains whole number(integer) types of fields, either, having gotten as a result NaN which is weird.

If you still want to sum the values of of Dropdown List Boxes use field1+field2+field3, having changed "Data type:" of all fields (including the one to which you insert the result) is "Whole Number (Integer)"

Summing up of multiple drop-down values

adrianodl — Thu, 20 Sep 2012 02:32:36 GMT

Hi all, this is what I'm trying to achieve:

I have a risk assessment form with determined values assigned to specific yes/no questions, with yes = 1 and no = 0.

What I want to do is to sum up the values of these multiple drop down boxes and then populate a text box with the result; so for example, if 3 out of 5 answers are yes, the risk is medium. If 5 of 5, it's high, and so on.

I know how to create the rules based on a a value, but I'm struggling with summing up the different values. I tried to use the sum(field1, field2, field3) function but it tells me the syntax is not right.

Any clues?

Thank you