Null count

[#1]

Hi,

I created a object for null count and its show me 1 count but column has no null value,

kindly guide me and i attached excel and application files.

Regards.

Zain.

[rbecher]

Hi Zain,

I think there is one representation of NULL for all missing KEYs from table OD. You will see the if you add KEY as a dimension.

- Ralf

[#3]

Yes i know, any idea to avoid in null count and key is also important.

-Zain.

[rbecher · Accepted solution]

This is an option, filter on another not key dimension:

nullcount({<COR.order_number={"*"}>} COR.return_detail_number)

- Ralf

[#5]

Thanks its working for me.

Regards,

Zain.