cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
New to using JMP? Hit the ground running with the Early User Edition of Discovery Summit. Register now, free of charge.
Register for our Discovery Summit 2024 conference, Oct. 21-24, where you’ll learn, connect, and be inspired.
Choose Language Hide Translation Bar
PTR50
Level II

formulas not working

I am using Windows and JMP 18

Im Having some problems with version 18
 
My most recent one is that calculation of formulas does not work.  So for example
 
I have two columns X and Y - both continuous numeric variables  If  make a variable  Z (also numeric continuous) and use a formula in it: X * Y
 
I get nothing  (just dots)
 
any ideas??
2 REPLIES 2
txnelson
Super User

Re: formulas not working

just use the formula

:X * :Y

or if "It" is the reference to the data table you could specify

It = current data table();
It:X * It:Y

The JMP Log might have an error statement

Jim
hogi
Level XI

Re: formulas not working

the easiest way to generate a new column: new formula column right click menu:

hogi_0-1721993204380.png

and then you can go to the Log and check the code ...

hogi_1-1721993290278.png