Sum function not working properly

#1

Hi there, I’m having difficulties getting two numbers to add properly when I update a record despite the formula preview showing they will work correctly.

I’ve tried using ++ as well as the sum function below.

SUM([pageVars.progressToGoal, data.myChallenges.progressToGoal])

Screen Shot 2020-07-13 at 1.25.31 PM|690x286

For context, I am adding a page variable number to the existing record. So perhaps there’s a better function to use.

Thanks!
William

#2

Wrap the parameters in NUMBER(). Most likely you’re using a form to write some numbers which are handled strings.

1 Like
#3

Thanks @Sasu_Makinen that did the trick!