AnsweredAssumed Answered

Summing value list contents

Question asked by 4dmaze on Dec 1, 2016
Latest reply on Dec 1, 2016 by 4dmaze

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