Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
BhargavDS
Level I

Count number of columns which have value

I have a table where I want to create a new column which tells the number of cells in that row which has a value in it. How do I do this?
My columns look like this for example:

Name, A, B, C, D

I need to know how many in A,B,C and D have values in every row. Some rows have values for all of them, and in some none of them have values.
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
uday_guntupalli
Level VIII

Re: Count number of columns which have value

@BhargavDS
      I am assuming you have a table that looks like this : 

image.png

 

  You can script your new formula like so : 

If( Is Missing( :name ),0,1) + If( Is Missing( :age ), 0, 1 ) +
 If( Is Missing( :sex ), 0, 1 ) + If( Is Missing( :height ),0,1) + 
If( Is Missing( :weight ),0,1)

 

 

Best
Uday

View solution in original post

3 REPLIES 3
Highlighted
uday_guntupalli
Level VIII

Re: Count number of columns which have value

@BhargavDS
      I am assuming you have a table that looks like this : 

image.png

 

  You can script your new formula like so : 

If( Is Missing( :name ),0,1) + If( Is Missing( :age ), 0, 1 ) +
 If( Is Missing( :sex ), 0, 1 ) + If( Is Missing( :height ),0,1) + 
If( Is Missing( :weight ),0,1)

 

 

Best
Uday

View solution in original post

Highlighted
txnelson
Super User

Re: Count number of columns which have value

The below formula is a simpler form but gives the same results as @uday_guntupall

Sum(:Name == "", isMissing(:age),:sex=="",isMissing(:Height),isMissing(:Weight))

@uday_guntupalli

Jim
Highlighted
Thomas1
Level V

Re: Count number of columns which have value

Did you try the following formula column?

 

N Missing( :A, :B, :C, :D )

Article Labels

    There are no labels assigned to this post.