Are you sure you want to sum the individual field scores? You will get different combinations producing equal values.
I'm assuming yes = 0 for the first field and that all the fields are text fields...
Make it a calculation field like this:
(Field 1 = "yes" ) +
Case ( Field 2 = "red" ; 0 ; Field 2 = "Blue" ; 1 // and so forth for each hair color) +
Case ( Field 3 = "<10cm" ; 0 ; Field 3 = ">=10 cm & <=20cm" ; 1 ; ">20cm" ;//you seem to be missing a value here)
The values in quotes have to match letter for letter a value list item you've defined for that field. (Field 1 = "yes") evaluates to 1 if true and 0 if false.
I'm no surgeon, but...
a) very very few people have blue hair
b) It'd be a very unusual surgery for which hair color would be significant.
Therefore I have assumed that you are using fairly abstract examples for a different application of the same issue. This can lead to misunderstandings and to wasted effort when we discover in your follow up posts that there were significant details left out of the original post...
Thanks for that,
Yeah I know what you mean, I thought i'd give an abstract example to avoid jargon, but the crux of what I needed to know about was there, a binary, categorical, and transformed continous variable.
You were right, I meant 0-2 in the feild 3 example.
The variables in field 3 are entered as continous variables, rather than as dummy variables ie. <10cm etc. How do i transform them in my equation?
Can you give some examples?
0, 2.5, 3.756 or
0 - 2, 2.1 - 4, >4
or something else?
Now that I think a bit more about it. I'm guessing you need this type of case statement
Case ( Field 3 < 10 ; 0 ; Field 3 < 2 ; 1 ; 2 )
case will go with the first true statement and the last parameter "2" is the value returned if all preceding expressions are false.