Hello, I am trying to create a calculation field that will add up all of the checked boxes in a Value List. It's for a time tracking sheet.

For example for each section there would be 4 checkboxes marked as ".25" each and if you check all four the end summary field with 1 hour (plus the other sections).

When I sum them in a calculation field it just concatenates the numbers as a string of text. How do I get each part of the value list to be treated as a number? I made the field a number with strict data type. Thanks to anyone that point me in the right direction. -Derryl

There are much better ways than a check box field for recording this data, but if you have a single field with up to 4 values selected, they are stored as text values separated by returns.

This expression, in a script step or calculation field could compute the sum:

Evaluate ( Substitute ( YourCheckBoxField ; ¶ ; " + " ) )