In most of the cases with JMP you will end up with something like this with all rows getting the same value depending on grouping you use:
![jthi_0-1627453815103.png jthi_0-1627453815103.png](https://community.jmp.com/t5/image/serverpage/image-id/34600iAC3E812C0620A687/image-size/medium?v=v2&px=400)
Col Sum(If(:Result == "Good", 1, 0), :Part)
I would most likely suggest using Tabulate or Summary. Using the same table:
With tabulate you can get this:
![jthi_1-1627453883557.png jthi_1-1627453883557.png](https://community.jmp.com/t5/image/serverpage/image-id/34601iFF2EF79E1E392551/image-size/medium?v=v2&px=400)
and with summary:
![jthi_2-1627453982806.png jthi_2-1627453982806.png](https://community.jmp.com/t5/image/serverpage/image-id/34602i77839944C7BDA76E/image-size/medium?v=v2&px=400)
If these are not sufficient enough, could you provide example table (and use case if possible), so better answer can be given.
-Jarmo