1 2 Previous Next 15 Replies Latest reply on Jun 27, 2017 11:22 AM by philmodjunk

    Checkboxes Value Calculation

    jarrodjb

      Good Day FM Community.

       

      Ill try to keep this simple.

       

      I have a table, Sections, with 2 fields,  Section and Value

      I have a check box field to display sections:section.

      Users check sections they are auditing.

       

      I want a sum of the checked values to be displayed in another field "ValueTotal" to help establish a numerator for use in another calculation down the rd.

      Did i miss something? Ive tried various calculations and Summary with zero success.

       

      All my ValueTotal field displays is the first in order check box item

      Example;

      anchor=4

      Pole=21

      ROW=19

      if both Anchor and Pole were to be checked should = 25, field displays 4

      If Pole and ROW is selected 21 is displayed, should be 40

       

      Thanks for your help!

      -J

        1 2 Previous Next