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!