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.