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.
|