count if is not null

[#1]

hi,

I have this .csv file:

ID product            quantity

        1                        123

        2                        456

        3                        789

        4                        Null

        5                        852

My problem is that I want to find a way to count, in a table, ID product only if the quantity is not Null

[sunny_talwar · Accepted solution]

May be this

Count(DISTINCT {<quantity = {'*'}>} [ID product])