FIlter in set analysis doesnt working function LEN

[netopst]

I´ve a table with

8865 rows where DT_INCLUSAO is null

But in count if i use = COUNT({<DT_INCLUSAO = {"=Len(DT_INCLUSAO)=0"}>} ID_TRABALHADOR)

returns no rows

I tryied:

COUNT({<DT_INCLUSAO = {"=Len(DT_INCLUSAO)=0"}>} ID_TRABALHADOR)

COUNT({<DT_INCLUSAO -= {"*"}>} ID_TRABALHADOR)

COUNT({<DT_INCLUSAO = {"=IsNull(DT_INCLUSAO )"}>} ID_TRABALHADOR)

COUNT({<DT_INCLUSAO = {"=Null()"}>} ID_TRABALHADOR)

COUNT({<DT_INCLUSAO = {"='null'"}>} ID_TRABALHADOR)

COUNT({<DT_INCLUSAO = {"=IsNull(DT_INCLUSAO ) or DT_INCLUSAO =''"}}>} ID_TRABALHADOR)

unsuccessfull 🥲

Opens in new window

PDF Download

Word Download

Excel Download

PowerPoint Download

Document Download

[rubenmarin]

Hi, you can try applying the set analysis to the ID_TRABALHADOR field:

COUNT({<ID_TRABALHADOR={"=Len(DT_INCLUSAO)=0"}>} ID_TRABALHADOR)