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 ...
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!