AnsweredAssumed Answered

Calculated Value Control turning total from Currency to String

Question asked by jocelynm on Mar 24, 2016
Latest reply on Mar 24, 2016 by jocelynm

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?

Outcomes