John Justus 4 Posted August 31, 2020 Share Posted August 31, 2020 All, I have an table like below. I want to get the row count for Col2 is empty. Col1 Col2 1 ABC 2 DEF 3 GHI 4 KEJ 5 6 7 Thanks, John Link to comment Share on other sites More sharing options...
Shashank Gurnalkar Posted August 31, 2020 Share Posted August 31, 2020 One approach would be: Integer(Sum(Case when [Col2] is NULL then 1 end)) Link to comment Share on other sites More sharing options...
John Justus 4 Posted September 1, 2020 Author Share Posted September 1, 2020 Great. Thanks Shashank. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now