Issue with correct output

Hey v-yadongf-msft,

thanks for getting back to me.

1. This one is the data from the forms excelfile which will be pushed into datase.
   
2. This one is the expected result built in an other excel file (that was the basic idea)
   
   
   

The 2nd pic shows you the initial idea of the evaluation which is now built with forms and the report.

Whats happens there:

By choosing one of the three options for each row (last colum), there will be created a total sum for each of the three columns (colums: 3, 6 and 9). Where the red box is, the sums will be compared and the biggest one will give back one of the three options: "Tagesgeschäft (daily business)", "Change" or "Project".

On report level I'm following the same idea by creating a sum for each of the answers (my last code block from initial post), that works very well and is double checked with that excel file.

My idea is to get the red box (screenshot) into a visual (first screen, 4th visual, initial post), by comparing the sums, like in the excel. For only one answer that will work very well, if I got more than one, its a total mess.

What I already found out is that the comparision of the sums works fine on each answer themselves but not in total over all answers.

Please let me know if you need something else.

Best regards,
Steffen