AnsweredAssumed Answered

Checkboxes Value Calculation

Question asked by jarrodjb on Jun 27, 2017
Latest reply on Jun 27, 2017 by philmodjunk

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

Outcomes