Let's start with this table (total_answers is there just to show correct amount):
![jthi_0-1629125443471.png jthi_0-1629125443471.png](https://community.jmp.com/t5/image/serverpage/image-id/35066iD8A36756920789CD/image-size/medium?v=v2&px=400)
1. Stack
![jthi_1-1629125490967.png jthi_1-1629125490967.png](https://community.jmp.com/t5/image/serverpage/image-id/35067i55FFFCB1380263A1/image-size/medium?v=v2&px=400)
2. Add formula (Column 6):
![jthi_3-1629125531212.png jthi_3-1629125531212.png](https://community.jmp.com/t5/image/serverpage/image-id/35069i949A50746656E8A3/image-size/medium?v=v2&px=400)
3. Tabulate (or summary):
![jthi_4-1629125579642.png jthi_4-1629125579642.png](https://community.jmp.com/t5/image/serverpage/image-id/35070i729433FB1E6F97E0/image-size/medium?v=v2&px=400)
Also take care that the column Data Types and Modeling Types are correct for the data you are modeling.
Example table with a bit more advanced formula which I wouldn't suggest using until you learn a bit more about JSL:
Names Default To Here(1);
dt = New Table("Untitled 4",
Add Rows(5),
Set Header Height(50),
New Column("question", Numeric, "Ordinal", Format("Best", 12), Set Values([1, 2, 3, 4, 5])),
New Column("student1", Character, "Nominal", Set Values({"A", "A", "A", "A", "A"})),
New Column("student2", Character, "Nominal", Set Values({"A", "B", "B", "B", "A"})),
New Column("student3", Character, "Nominal", Set Values({"A", "B", "C", "C", "A"})),
New Column("student4", Character, "Nominal", Set Values({"A", "B", "C", "D", "A"})),
New Column("student5", Character, "Nominal", Set Values({"A", "B", "C", "D", "A"})),
New Column("right_answer", Character, "Nominal", Set Values({"A", "B", "C", "D", "E"}))
);
//Don' use if you don't have clear understanding what this does! Try first using data table method
//2::5 indicates indices of student result columns
dt << New Column("Total_answers", Numeric, Continuous,
<< Formula(
N Items(Loc(Current Data Table()[Row(), 2::6], :right_answer))
)
);
-Jarmo