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.

      Thanks,

      Sasi