Forum Discussion
Numbers of rows where is not null
Hello developers, I would like count the numbers of rows where is not null ? Do you have an idea ? Thanks ! Column 1 Column 2 Column 3 RESULT 2 null null 1 null 6 7 ...
I misspoke,
I would like create new column 'Result' for have the same output like my exemple in the first topic.
Hi,
in the attached file you can find 2 solutions (i don't really know what you need)
If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!
Thanks a lot serpiva,
but in my table i have other columns, i would like function work with precise my columns.
Examples
Other column ... Other column ... Column 1 Column 2 Column 3 RESULT ... ... 2 null null 1 ... ... null 6 7 2 ... .... null null null 0 ... ... 4 7 10 3 Hi, you obtain your result by applying the steps of the attached file
If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!