I have a query returning "unique IDs" and their "account creation dates." What I want to achieve: create a calculated field - Count distinct no. of "Unique Ids" where "account creation date" is not NULL.
You can write the calculated field and the code like below-
this will test both the condition for not null and unique.