IF/Else formula - how to return a blank cell
I am creating an conditional formula. If the condition I am evaluating is false, How do I return a blank cell? If( :Orientation == "X", :"X Ave"n / 100, ??) I want to evaluate a column and if it is...
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesI am creating an conditional formula. If the condition I am evaluating is false, How do I return a blank cell? If( :Orientation == "X", :"X Ave"n / 100, ??) I want to evaluate a column and if it is...
Hey everyone, I am trying to rename a " New Formula Column" that can have different amounts of columns that get summarized, the default column name out is always changing. However, I can't fin...
Hi all, I try to understand the example of hierarchical clustering (picture below) with a distance matrix from JMP here: https://www.jmp.com/support/help/14/example-of-a-distance-matrix...
...ow? Here's an example of what the collected data table looks like (censored because of sensitive info). And here are a couple graph ideas I have in mind (I'm not f...
Hi there, I'd like some assistance/comments on how to perform a mixed model analysis in JMP, as it seems to be the most suitable for my data. I'm looking to compare within-group differences in p...
Hi all, I try to understand the example of hierarchical clustering (picture below) with a distance matrix from JMP here: https://www.jmp.com/support/help/14/example-of-a-distance-matrix...
Hi All, I have some production data that I'm analyzing with the MDMVCC platform. Specifically, after running the analysis and selecting those rows that have the most extreme T^2 value...
When i plot multiple plots with the same x-axis weere the graph is of 3rows x 1 column. And I zoom in one plot, and then zoom in another plot. and then change the plots type, say, from line to scatte...
My excel formula is: =+IF(AND(E98=1, E108=1), IFERROR(E121-E$128, "NA"), "NA"). E98 = 1. E108 = 1. E121 is a calculation that came out to .267993337. E128 is a calculation that came out to -0....
i have a values for six bioreactors for a parameter and cell days as the x-axis. I would like to overlay those values on the historical mean and 95% confidence interval as a function of c...
My excel formula is: =+IF(AND(E98=1, E108=1), IFERROR(E121-E$128, "NA"), "NA"). E98 = 1. E108 = 1. E121 is a calculation that came out to .267993337. E128 is a calculation that came out to -0....
Hi, I'm trying to run daily scheduled job, but keep getting failing error "Process is terminated due to StackOverflowException". What might be the reason for this?
Did you notice that PickFile looks different when it's opened from within a project? More than that - when Pick File is opened from a project, with mydir pointing to a network drive with...
I'm a beginner in application builder, I use spacerbox, sometimes the width can't be adjusted, sometimes the height can't be adjusted
w = New Window("window", <<Journal, hlb = hlistbox() ); w << Set Print Headers( "lineone \!n linetwo", "", "Page &pn; of &pc;" ); w << SavePDF ( "C:\Users\blahblah....
Topic: Building Robust and Fail-Safe Scripts Registration page: https://www.jmp.com/en_gb/...
This webinar is in English, 2:00 p.m. US Eastern Time. Learn to fit models using variable sel...
REGISTER HERE: https://www.jmp.com/en_us/events/live-webinars/academic/jmp101-28aug2024.html ...
This webinar is in English, 2:00 p.m. US Eastern Time. Learn how to publish data, dashboards...