Adding (sum) of Multiple Category Fields

Follow

Randy D

• December 01, 2020 01:48
• Edited

I have created a "Survey App" with category fields where by which the "answer selection" is a number 1-5.

 

Example:

How would you rate our service:

1

2

3

4

5

 

There are a total of 10 category fields and I'm wondering if I can now add a "calculation field" that will add these answers.

 

So if the user selected 1, 4, 4, 5, 4, 1, 4, 4, 2, 5 / Then the total in the calc field would be: 3 or 3.4

 

How can this be done?

0

• 

  Rainer Grabowski

  • December 02, 2020 09:10

  Hey Randy,

  var cat1 = Number(@category field 1) || 0;
  var cat2 = Number(@category field 2) || 0;
  and so on for all 10 category fields.
  
  var sum = cat1 + cat2 + and so on 
  sum
  
  If you want the avg.:
  sum / 10

  Rainer

  0

  Comment actions Permalink
• 

  Kevin Eckley

  • December 04, 2020 15:30

  Rainer Grabowski Are you available for hire on a Podio project? There are a number of calculations/automations that I would love to run on Podio, but lack the technical ability to create. Please let me know if this is something you would consider, thanks!

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • December 05, 2020 19:23

  Kevin Eckley Yes, I'm available for hire (I'm an Authorized Podio Partner). You can contact me in Podio or via email: grabowski.rainer@gmail.com.

  0

  Comment actions Permalink

Please sign in to leave a comment.