Jim,
You are most welcome. JMP can be wonderful at times and frustrating at other
times, so when I've spent hours hitting my head against the wall trying to
figure something out, it's actually quite nice to be able to share it with
someone.
Yup, I'm in Australia, Melbourne to be exact. Australia is a great place to
visit, esp Queensland Gold Coast, Great barrier reef, etc, but, as the Aussies
would say, it's a bloody long flight.
Cheers
Gunter
-----Original Message-----
From: jmp-l-owner@lists.biostat.wustl.edu
[mailto:jmp-l-owner@lists.biostat.wustl.edu]On Behalf Of James T Metz
Sent: Thursday, 8 September 2005 12:10 PM
To: jmp-l@lists.biostat.wustl.edu
Cc: James T Metz
Subject: Re: [jmp-l] Need help creating a JMP formula
Gunter,
Woah! You are da man !!!
Yes, your formula is EXACTLY what I was looking for ( I made a mistake
for Bob in my manual counts using ">=" vs purely ">",
but I see my mistake now).
I could not figure out how to do this - my brain must have burped.
Thanks for the tremendously quick and helpful response. I owe you if I
ever make it to Austrailia (I think that is where you are
judging from your email)
Thanks again!
Regards,
Jim Metz
James T. Metz, Ph.D.
Research Investigator Chemist
GPRD R46Y AP10-2
Abbott Laboratories
100 Abbott Park Road
Abbott Park, IL 60064-6100
U.S.A.
Office (847) 936 - 0441
FAX (847) 935 - 0548
james.metz@abbott.com
This communication may contain information that is legally privileged,
confidential, or exempt from disclosure. If you are not the intended
recipient, please note that any dissemination, distribution, use, or copying of
this communication is strictly prohibited. Anyone who receives this message in
error should notify the sender immediately by telephone or return email and
delete it from his or her computer.
<Gunter.Hartel@csl.com.au>
Sent by: jmp-l-owner@lists.biostat.wustl.edu
09/07/2005 08:55 PM
Please respond to jmp-l
To: <jmp-l@lists.biostat.wustl.edu>
cc:
Subject: Re: [jmp-l] Need help creating a JMP formula
Jim,
IS the following what you're looking for?
k = 100; Sum( :Bowling Score A >= k, :Bowling Score B >= k, :Bowling Score C
>= k)
Cheers
Gunter
-----Original Message-----
From: jmp-l-owner@lists.biostat.wustl.edu
[mailto:jmp-l-owner@lists.biostat.wustl.edu]On Behalf Of James T Metz
Sent: Thursday, 8 September 2005 11:47 AM
To: jmp-l@lists.biostat.wustl.edu
Cc: James T Metz
Subject: [jmp-l] Need help creating a JMP formula
JMP Users,
Can someone please help me create the following formulas?
I have a JMP data table for which I need to create 4 separate formulas
to generate counts across a row,
for each row, using selected columns according to particular numeric selection
criteria (IF statements, I would assume?).
Somehow I need to create a summation according to the specific column names and
use IF statements with an
incrementing counter, but I can not figure out how to do this using the Formula
editor in JMP.
I have attached a small, sample JMP file and a comma-separated text
file (for those of you who can not
receive the JMP file) below to illustrate what I need to be able to do. The
JMP file is, of course, made-up data.
Essentially, I need to create formulas for the last 4 columns i.e.,
Number of Bowling Scores > 100, Number of Bowling Scores
> 150, etc. I have manually entered the counts so that you will understand the
> numbers that should appear using the formulas.
I would be most grateful for any and all suggestions!
Regards,
Jim Metz
James T. Metz, Ph.D.
Research Investigator Chemist
GPRD R46Y AP10-2
Abbott Laboratories
100 Abbott Park Road
Abbott Park, IL 60064-6100
U.S.A.
Office (847) 936 - 0441
FAX (847) 935 - 0548
james.metz@abbott.com
This communication may contain information that is legally privileged,
confidential, or exempt from disclosure. If you are not the intended
recipient, please note that any dissemination, distribution, use, or copying of
this communication is strictly prohibited. Anyone who receives this message in
error should notify the sender immediately by telephone or return email and
delete it from his or her computer.
|