2 Replies Latest reply on Dec 1, 2016 3:37 PM by 4dmaze

    Summing value list contents

    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