Caution: Places where Jmp does something unexpected

[#1]

Definitely, JMP is Not a Spreadsheet .

Besides this difference, there are more places where Jmp doesn't do/behave/produce what an newbie / innocent / medium / pro  Jmp user expected. For some of the topics there exists a workaround.

[More Topic Containers like this]

Topic	description	Links
Data Tables
Formula column + excluded rows	Unlike plots and reports, column formulas by default don't use the information about which rows are excluded. Workaround:  col mean(:height, excluded()) Caution: With Jmp < v18, just use the workaround  for small tables - the formula will be triggered with every (!) row selection!	Formula Editor: meaningful results with excluded rows Compute Column Mean while restricting observations usedJMP10: Col Max() and Col Min() functions returned the data from excluded row Col Functions and Row States  Exclude data in formula  Why-does-selecting-deselecting-rows-trigger-column-formulas
Formula Column + Namespaces	formula evaluator doesn't plays well with namespaces *): re-evaluation is triggered when a cell in the table is selected. *) e.g. if a custom formula or a scoped variable is used in a column formula	Workaround:  What makes the formula evaluate over and over?
Source Scripts + Tables/Update	The Platform Tables/Update *) overwrites an existing Source script *) same issue for Tables/Concatenate with option: Append to first table	Update & Concatenate: source script collision workaround: treat the source script as something temporary
Table/Summary + DataFilter + missing values	Jmp crashes or returns wrong values when the data filter doesn't find a matching row. Local DataFilter shows a similar issue	2 bugs with Tables/Summary  Outlier (👽) screening with Jmp Dashboards - how?
issues with date	JMP universe is based on M.D.Y  this can lead to severe issues with D.M.Y	CSV import force MDY or DMY date format
blocked data tables	it's not possible to sort a table, to concatenate tables or to add rows if a linked subset or a report is open	Sort data table + add rows + concatenate -> make it possible
JSL
issues with missing wait(0)	execution of a script has to be paused till JMP updates the data / display	When to use Wait(0)?
Graph Builder
Graph Builder + Heatmaps	the automatic adjustment of the axis scale makes it difficult to plot wafermaps in Jmp.	Heatmap - option: fixed Tick spacing (aggregation area)
Graph Builder + manual axis labels	Manual axis labels are mixed up when columns are added, removed or dragged to a different position	Manual axis labels are 'mixed up' when plotting multiple columns