Calculating alternate values based on numbers in fields
I am dealing with a questionnaire where each question has a pop-up menu with answers.
Each answer has a number from about 1-6, and they work fine when calculating the fields.
What i need thelp to do is giving the answer fields values based on what answer they have. For example: If a field has the answer with numbers 1-4 its equivalent to a value of 0, but if the answer is >4 it will get a value of 1.
Then I need to be able to calculate these values (''1'' or ''0'') into a normal calculation field.
Thank you :)
define a calculation field with "number" as the result type. Then the following expression will produce the value that you want:
YourAnswerField > 4
This assumes that YourAnswerFieldis also of type Number.