Count Zeros in Column and expression

[lucasx15]

Hello everybody! I'm trying to count zeros in a line, however, the value is returning null. I have NR_CLIENT_NUMBER as dimension.

This is my expression:

IF(COUNT({<CD_POSTAL={605}, SEQ_TYPE={5757}>}DISTINCT NR_CLIENT_NUMBER)=0, COUNT({<CD_POSTAL={605}, SEQ_TYPE={5757}>}DISTINCT NR_CLIENT_NUMBER))

[BrunPierre]

Maybe like this?

Count({<NR_CLIENT_NUMBER={"=COUNT({<CD_POSTAL={605}, SEQ_TYPE={5757}>}DISTINCT NR_CLIENT_NUMBER)=0"},CD_POSTAL={605}, SEQ_TYPE={5757}>} DISTINCT NR_CLIENT_NUMBER)

[lucasx15]

Hi, @BrunPierre !

Thank you for reply!

I used this expression, however, it returned 0 and not the count of lines with zero. In this case, it should return 7 and not 0.

[BrunPierre]

Sum(If(Count({<NR_CLIENT_NUMBER={"=COUNT({<CD_POSTAL={605}, SEQ_TYPE={5757}>}DISTINCT NR_CLIENT_NUMBER)=0"},CD_POSTAL={605}, SEQ_TYPE={5757}>} DISTINCT NR_CLIENT_NUMBER)=0,1))