Adding numbers together to from a total

Hi @Miff 

1. Can you provide some more detailed information with screenshots of your Form/Questions?

2. How do you score each Question? What form controls are you using?

Hi @Miff 

Seems straight forward enough.

Can you confirm that all the column (and form controls) are integer or decimal and NOT text types?

You need to convert-to-Number any Text fields.

Sample form with 3 text fields

Sum variable. Since the text field is Text-type, we need to use the convertToNumber function

Sample outcome

Hi @Garrett, I'll look and let you know

thanks

Hi @Miff 

Another alternative is just to use SharePoint calculated column. 

This is probably more easier for your case as all the values are already in the other columns

Hi @Garrett 

how do get to that?

Google - SharePoint calculated column. 

Create a new Column. Type is Calculated. Define the formula

@Garrett thanks for your help, all sorted 👍

That’s great 😃 

Could I ask for a Kudos, just click the orange hand icon 👍 in the kudos box. This will encourage me to be more helpful to this community.