Set Analysis with dates greater than and missing dates

[PamelaAlcantara]

Hi all,

I am trying to get the number of items that have an initial_date after April 2019 and a closed_date that is not missing.

I have tried the following formula, but I keep getting errors,

count({<Initial_Date={'>=04/01/2019'}, Closed_Date-={"*"}>} items)

Thank you in advance for your help!

Pamela

[sunny_talwar · Accepted solution]

You want closed date which is not missing? Why do you have a minus sign then? Try this

Count({<Initial_Date = {">=04/01/2019"}, Closed_Date = {"*"}>} items)

[PamelaAlcantara]

Yes, I wanted closed date which is not missing. Sorry, that was my bad, I thought the expression {"*"}  was looking for the missing values.

Thank you!