So I was solving this assignment and stuck with the step to get the average of the subjects.
I have merged the 3 sheets into one. But I am not able to understand how to get the average of the columns (subjects). Even I tried with Modified Java Script Value but it gives me data for each row, how can I sum the value of a column and get that in a variable. Is there any way to run a loop.
Combined data:
Update:
I am able to get the average now by using ‘group by’. But How to achieve the same using Modified Java Script Value Step.