SUM function not working the way I expected - Help!

[Howard Salberg 0]

Hello All,

I have created a form with fillable fields.  I need the sum of all the monetary values from all the fields to show up in one text field at the top.  It was working fine until I added some additional fields to the form and now none of the fields are being added together.  Nothing shows up in the SUM target field.  I'm using the standard built in sum feature via the properties for this target form field. I also noticed that a couple of the fields that I selected to be part of the sum were unchecked ( not by me ) when I went in to check the properties.  Is there a limit on the number of fields that can be added together with the built in SUM function, or are there other things that can "break" the sum feature?  Thanks for your help.

Howard

 

Edited November 22, 2019 by Howard Salberg