@BhargavDS,
I am assuming you have a table that looks like this :
![image.png image.png](https://community.jmp.com/t5/image/serverpage/image-id/10541i4FAC75074C9C2377/image-size/large?v=v2&px=999)
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