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!

Hi,

if you use the following formula you can solve your issue:

sum([1,2,3,4,5])it's similar to your fouth test but it has an array as argument (if you check the description of the sum function, you can see that it asks for a set of values inside brackets).

Giacomo