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 ...
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 |
serpiva64
Solution Sage
Solution SageHi, 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!