Sum function for non numeric choice field?

  • 21 March 2022
  • 2 replies

Userlevel 3
Badge +8

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 21 March 2022, 23:27

View original

2 replies

Userlevel 3
Badge +8

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


That's all.


Thank you

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