cancel
Showing results for 
Search instead for 
Did you mean: 
jocelynm
Nintex Newbie

Calculated Value Control turning total from Currency to String

Jump to solution

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?

0 Kudos
Reply
1 Reply
jocelynm
Nintex Newbie

Re: Calculated Value Control turning total from Currency to String

Jump to solution

My searching skills need some work, I just found the answer here: Calculated value Nintex Forms / Plus sign not working?

try: sum([Namecontrol1, Namecontrol2])

View solution in original post

Reply