Can a formula be calculated based on a numerical response in "If/Else conditions"?

Questions and Help
1

I am creating a scorecard to review our customers product usage. I have 5 topics, all scored 1-5 based on various answers of each topic.

  1. Is there a way I can use the "average" command to get the average of all the topics in the chart?
  2. Is there a better way to set this up besides "If/Else" conditions?

image
image1125×652 127 KB

2

Hi @Erin_Towell, welcome to the forum. :slight_smile:

For (2), I'd suggest including the score as a prefix for the choice, this way we can extract the score easily with a simple formula.

Now for (1), we can assign those scores to variables then calculate their average. I created a simple example to show you how to do that, I hope it helps.

Communication: {formmenu: default=1. Very Poor; 2. Poor Communication; name=comm}
Score: {score1=split(comm, ".")[1]}{=score1}

Engagement: {formmenu: 1. Very Poor; default=2. Poor Communication; name=engagement}
Score: {score2=split(engagement, ".")[1]}{=score2}

{=average([score1, score2])}

4

I got it, thank you!