Is this one field or 5?
Hi, its five separate fields with a check box (ticked or unticked) next to each field. When ticked I want to assign each field a value of 1 so that ecah tick represents 1, hence if all are ticked the total is 5
Create a Calculation Field and use the ValueCount ( ) function.
so if your field is called "RiskFactors", your "TotalScore" calculation field would be:
ValueCount ( RiskFactors )
Count ( Field1 ; Field2 ; Field3 ; Field4 ; Field5 )
BTW, if you used a value list of "1", you could simply sum the fields.
Sorry, didn't see the post that you have 5 separate fields.
ValueCount will only work if you create a Value list using the Risk Factors you have.
Found a way; you simply use 'int' and assign a +1 to each box, then create a total score box with a calculation that simply adds up the total. Cool