topic Re: Is Missing command- Scrippting in Discussions

Is Missing command- Scrippting

GroupSquareWolf — Fri, 09 Jun 2023 15:58:24 GMT

In this example, ;"Sum of A+B+C" calculates sum of :A + :B + :C in each row with this formula:

If( Is Missing( :A ), 0, :A ) + If( Is Missing( :B ), 0, :B ) + If( Is Missing( :C ), 0, :C )

If I change the specific column names to with column number, the script is not working anymore and generates an error

If( Is Missing( Column( 1 ) ), 0, Column( 1 ) ) + If( Is Missing( Column( 2 ) ), 0, Column( 2 ) ) + If( Is Missing( Column( 3 ) ), 0, Column( 3 ) )

What am I missing here?

Re: Is Missing command- Scrippting

jthi — Tue, 13 Sep 2022 17:52:58 GMT

If you are using Column() I think you will also have to provide row number. For example:

Column(1)[Row()]

(AsColumn(Column(1)) might also work).

Also using

Sum(:A, :B, :C)

should work without IsMissings

Re: Is Missing command- Scrippting

ErraticAttack — Tue, 13 Sep 2022 20:15:25 GMT

Put a [] at the end of your Column() functions:

Re: Is Missing command- Scrippting

Jeff_Perkinson — Wed, 14 Sep 2022 01:17:49 GMT

@jthi wrote:

Also using
Sum(:A, :B, :C)
should work without IsMissings

I would second this. It looks like you're just trying to avoid the propagation of missing values that the + operator does and, as @jthi points out the Sum() function does just that. More information here:

Re: Is Missing command- Scrippting

Craige_Hales — Wed, 14 Sep 2022 02:54:45 GMT

The empty square brackets tell JMP to index the current row of the column. Using [row()] is the same idea. Without them, the data type is a column, not a number, and isMissing requires a numeric argument.

The sum() function is a great choice for this.