@BhargavDS,
I am assuming you have a table that looks like this :
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)
@BhargavDS,
I am assuming you have a table that looks like this :
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)
The below formula is a simpler form but gives the same results as @uday_guntupall
Sum(:Name == "", isMissing(:age),:sex=="",isMissing(:Height),isMissing(:Weight))
Did you try the following formula column?
N Missing( :A, :B, :C, :D )