AnsweredAssumed Answered

Calculating the sum total of multiple text controls

Question asked by M S on Jun 29, 2016
Latest reply on Oct 9, 2018 by kollideep@gmail.com

Hi,

 

I have a form with a few Text controls (data type: decimal) and Calculated Value controls that totals the contents of those text fields that looks like this:

 

NOTE: The text controls are named 1, 2, 3, 4, 5 as specified by their corresponding labels.

NOTE: The calculated values contain the calculations as specified in their corresponding labels e.g. 1+2+3+4+5 or sum(1+2+3+4+5), etc

 

I've used 4 calculated values for demonstration purposes where the first calculated value is what I assume to be the correct syntax and works correctly. The remaining 3 are deliberately incorrect.

 

Now if I delete a value from one of the fields the formula breaks:

 

 

The first two values are totaled but the null value then breaks the sequence and the subsequent values are concatenated.

 

At the moment I can work around this by using a zero instead of null but I would like to know if I'm doing something obviously wrong with the calculation.

 

Thanks!

Outcomes