Formula to sum up totals in survey

i would have the respondent enter the mileage and the # of busses and then add a formula(calculation) as embedded data in the survey flow. 

@lisagilchrist  you can use formulas within the in the survey flow to create embedded data fields that then could be piped into the survey. You can read about those here. 

Thank you both, I will try that!

I think constant sum as a question choice would be the way to go:

https://www.qualtrics.com/support/survey-platform/survey-module/editing-questions/question-types-guide/specialty-questions/constant-sum/ 

However if this isn’t working for you, without knowing the specifics, it would be worthwhile to follow up with a ticket.

If you decide to keep the text entry format adding a validation → content type → number would clean up some of the data and you could always work within the Excel sheet once you export it to sum totals.

Ok - help - I set up new questions to create totals. Then I set up embedded data to calculate the totals. Then I set up new questions to display the totals using Piped Text. And I get “Invalid Expression”

@lisagilchrist  You have some problems with your formulas. 

Almost there, now I am getting 0 for each instead of Invalid Expression. 

@lisagilchrist  Are the questions where you’re collecting the data above the formulas? If not, move the embedded data fields lower in the flow so that the questions where you collect the data come first. If you’re piping the data back into the survey, you’ll need tomake sure that those questions are after the embedded data. 

Woooooooooooooooooo! That worked!