430425_en-US

liliconcom

JMP script to substract column value, if nth column have no data i need to take N-1 column value

Hi Team,

 

Please help to suggest some solution for below issue

Need to create a script that can work in both situation,

column 8 = column 7-column6 

but if column 6 is having empty cell then , column 8 = column 7-column 6

 

Note: column name is variable control

Input:

 

 

 

AnalyticsData TableScriptingRe: JMP script to substract column value, if nth column have no data i need to take N-1 column value

You could use the IsMissing() function with If statements:

 

If( Is Missing( :Column 6 ),
 :Column 7 - :Column 5,
 :Column 7 - :Column 6
)