1 Reply Latest reply on Aug 25, 2016 1:36 AM by Manideep Bhattacharyya

    Windows Sum of count excluding the null values

    Sasiaknth Reddy

      Hi All,


      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.


      Kindly suggest.