I´ve created a script where I create a variable for later calculations and I´ve run into two things I cannot explain:
1) On several occasions I´ve seen that running the script twice doesn´t provide the same result. As you can see the first result is a mean of the entire column whereas the second is a single value (the one I need).
2) I´ve also seen that suddenly jmp can´t seem to find the column I´m referring to ("Mean(VO2_M)") even though it has worked fine 5 minutes earlier. If I then copy paste the exact same column name in it´s place it works again. Even though there is no difference at all.
to isolate this script from other scripts that may have previously run during your JMP session?
Do you have a Name Space called "1st Run"
This syntax with the ":" in it indicates that a Name Space or Data Table is available in your JMP session
You are referencing a non specific data table for your "Mean(Vo2_M)" column
:Name( "Mean(VO2_M)" )
This form of referencing of your column will look in the Current Data Table (I.e. the last one created, or the last one purposefully clicked on or unintentionally clicked on). You should change the reference to make sure it is pointing to the correct data table
dt = Data Table("name of data table");
dt:Name( "Mean(VO2_M)" )
I suspect one or more of these issues are causing your probilem