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

    Checkboxes Value Calculation


      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





      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!


        1 2 Previous Next