topic Re: Invalid Rate Percentage in Discussions

Invalid Rate Percentage

BiasedIguana305 — Mon, 13 May 2024 08:49:27 GMT

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.

Re: Invalid Rate Percentage

jthi — Mon, 13 May 2024 10:33:07 GMT

Check out Summary platform to create new table with aggregated data. You can then perform calculations there

Re: Invalid Rate Percentage

txnelson — Mon, 13 May 2024 13:48:28 GMT

Welcome to the JMP Community.

Jarmo's response correctly points you to the JMP Platform that will solve your specific question. In addition to pursuing that direction, I also encourage you to take the time to explore JMP. The tools for new JMP users to learn JMP are located under the Help pull down menu.

If you are using JMP 18, the "Learn JMP" selection provides "The one place to access all JMP learning materials".

Earlier versions of JMP have selections for the Discovering JMP document and Tutorials, along with a selection that will open the complete JMP Documentation Library.

And of course, the JMP Discussion Community is there to provide additional help when needed.

Re: Invalid Rate Percentage

BiasedIguana305 — Mon, 13 May 2024 15:13:26 GMT

Thank you I will into that section.

Re: Invalid Rate Percentage

BiasedIguana305 — Mon, 13 May 2024 15:20:18 GMT

Thank you for being kind for pointing me to the right direction. I am very new to JMP and was a bit confused navigating all of the resources. I will

Re: Invalid Rate Percentage

LuzBosco — Wed, 12 Jun 2024 08:04:31 GMT

Thank you for answering, that is very helpful.