cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Have your say in shaping JMP's future by participating in the new JMP Wish List Prioritization Survey
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 XI

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 XI

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]