cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
  • Graph Builder Toolbar streamlines interactive graphing. Creates shortcuts on Report and GraphBuilder Helpers toolbars. Download and install the extension.
  • JMP will suspend normal business operations for our Rest and Recharge Day on Friday, October 2, 2026.
    Regular business hours will resume on Monday, October 5, 2026.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar

How do I copy and paste a formula

I am using 

ExpectedLlama88_2-1715197788665.png

I am trying to paste the following formula from one data table to another (similar) table:

ExpectedLlama88_0-1715197582318.png

However when I paste it into the new table I get an error message and the formula will not work

ExpectedLlama88_1-1715197679259.png

How do I resolve this so that the formula will operate properly?  Thanks

11 REPLIES 11
hogi
Level XIII

Re: How do I copy and paste a formula

issues and explanations:

 

  • hogi_0-1715635302682.png
    you tried to paste the formula into column "Day". this leads to a loop day = f(day) - and the evaluation is interrupted.
  • hogi_1-1715635392621.png

    you renamed the input column day -> "Day of week"
    no column "day" -> formula complains

  • Character vs. Number issue.
    your original formula need "day" as Character, but in the new table "day" is a number
    --> open the column properties and change the data type from numeric to character

 

hogi
Level XIII

Re: How do I copy and paste a formula

But as "Day" is numeric in your new table, the easiest solution is:
right click on the column header and go to New Formula Column / Date Time / Day of Week Name

hogi_2-1715635607413.png

Then Jmp will generate a new column Day of Week[Day]

Recommended Articles