I am trying to find the windows_Sum ( Count ( [No of Roses]),-11,0)
But I wanted to exclude the Nulls ( not zeros) in [No of Roses] filed.
P.S : Am calculating for last 12 months values.
Try this - WINDOW_SUM(COUNT(IFNULL( [No of Roses],0)),-11,0)
Retrieving data ...