Invalid Rate Percentage
1. I have 2 columns for total number of runs (A) and number of failed runs (B). I want to have the % of invalid runs by JMP. When I do it in Excel, I would do sum of column B divided by sum of column A. How can I do that in JMP please? And how to put that number in a report form? Is there a way to put that % in chart form?
2. There is a column for me to mark either True/False for each row. And I want to find the % of False out of the total in that column. How can I do sum of False divided by the total (True and False)?
Thank you for your time.