weighted averages from different columns

For instance, what is Q1b all correct. Is it a score out of a test?

ok, so overall within the responding tab, Blue A is worth 5 points so Q1b and the added response would each be 2.5. How would I add that?

For the blue folder:
Double tap on header: (Column properties )
Calculation > Weighted average (equal weights)
Grade type Result > Generic 5. This will yield a result out of 5

If Q1b and 1b are scores out of 2.5: Double tap on each header > Grade type > Generic 2.5

PS: Q1b and 1b do not have to add 5 for this to work. They could be scores out of 1000 and 2000. The folder will still yield a result out of 5. The main thing is for each column to 'know' the kind of values it will hold.

I will change this now

Great. I've seen you've selected 'Counter' as the column's cell editor inside this blue folder
This will let you add points with a double tap on the cell but I'm not sure if this is the way you'd like to work. If you change the cell editor to automatic it will be a Keypad which may be faster to use.

So I changed that, now would I apply the same to the other sub tabs?

Would I be able to change the grade value in the Blue Tab, because if I remove a value, leaving the score of 2.5, the grade is an E (technically for this tab the grade should be a C)

I have just sent a new email, with an update, Can you please check and advise? Thank you

It depends on the percentages assigned in the A to F.
2.5 out of 5 is 50% and in the current configuration it is an E

You can change these percentages in Menu > Grade type > Text grades A to F
or if you let me know how that C should be calculated I'll look into it

Thank you. I have one last question for now please.

what formula would be needed to say that is a columns value is 1 then the result must be 0?