Hello,

I have four items would like to SUM. They are separate columns: Item 1 Cost, Item 2 Cost, Item 3 Cost, and Shipping. I added a Calculated Value Control and have the following function=Item 1 Cost+Item 2 Cost+Item 3 Cost+Shipping.

This works when everything is filled out and the numbers are added together.  But if a column is skipped, it turns into a string. For example:

Item Cost 1 Cost: $1

Item Cost 2 Cost: $2

Item Cost 3 Cost: $3

Shipping Cost: $5

Total Cost: $11 <-working, adding numbers together.

Item Cost 1 Cost: $1

Item Cost 2 Cost: $2

Shipping Cost: $5

Total Cost: $35 <-when it hit the blank value, it turned into a string. So it added 1+2 and then did a concat on the 5.

Would anyone know how to fix this?