cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. ET on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

Solve problems, and share tips and tricks with other JMP users.
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 XIII

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

 

Recommended Articles