Aggregation of multiple choice answers causing problems for reporting

@Vicenza Consulting - if you have logic rules in your typeform that provide for scoring or evaluation of totals, then you would have the values you seek in variables in the form. as long as your logic calculations are correct, the values should be right

when you connect to Google Sheets, you are simply getting the answers and variables pushed into the cells. there is NO logic that is carried forward into the google sheet from typeform to do the calculation. 

you would have to set up your google sheet with the appropriate formulas etc to do that work.

if you need to ‘parse’ multiple choice entries from one cell into multiple columns, use the split() function. 

des