Dear friends, how can i calculate numbers of null and not null numbers in my table?
i want to calculate numbers of null value by each year. Is it possible?
How do you want the information displayed?
You could do something similar to this:
WINDOW_SUM(IF ISNULL(SUM([Sales]))THEN 1 END)
Retrieving data ...