Skip to main content
Nintex Community Menu Bar
Solved

Sum function for non numeric choice field?

  • March 21, 2022
  • 2 replies
  • 105 views

kmccool
Forum|alt.badge.img+9

Hey all, 

 

How do I sum non numeric values using the sum function and  setting values using the if function within? 

 

Here's my example formula, it works if it only has one value assigned, but when I add  another field to assignment, it doesn't add it to the sum. (I'm trying to assign a number value to the multiple choice questions they get correct)

 

Works:    sum(If(contains(Question1,"a."),1,0))

 

Doesn't work:   sum(If(contains(Question1,"a."),1,0),If(contains(Question2,"a."),1,0))

 

What am I missing?  It's probably a comma or something like that. 

Best answer by kmccool

um, yea, I forgot brackets [ ] ...

 

That's all.

 

Thank you

2 replies

kmccool
Forum|alt.badge.img+9
  • Author
  • Scholar
  • Answer
  • March 21, 2022

um, yea, I forgot brackets [ ] ...

 

That's all.

 

Thank you


  • June 15, 2022

Yes, easy to do since the documentation is incorrect. I let them know. This cost my company several man-hours to "figure out."