Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
caiogil1
Contributor III
Contributor III

Counting Null

Hello everyone,


The task looks easy but I am stuck on this, so anyone know how to count null like in the image

123.PNG

I wanna count all the null cells in that table on the right, this means every day that there is no sale(measure field = qty_sold)

Just explaining a bit more
I have an master calendar (day,month,year...) creating every day from the min(date) to max(date)

This formula gets all the day that are not null but I wanna just the opposite

Count({$<QTD_VDA_UND-={"=Null()"}>}distinct DTA_AGENDA)

someone to help??

I hope to learn a lot here and help if I can
Labels (1)
1 Reply
Not applicable

Count({$<QTD_VDA_UND-={""}>}distinct DTA_AGENDA)