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