3 Replies Latest reply on Aug 6, 2018 5:42 AM by Naveen B

    Force blank to 0

    Pearl.pat.0

      I am using calculation something like and i want is when there is no data instead of blank i want to see 0. I tried so many calculations but nothing worked. I tried Zn, Ifnull,Isnull.

       

      IF  COUNTD({ FIXED [xyz],[Complaint ],[Product],

          DATETRUNC('month',[Year-Month ]):([Product diff])})>=0.01 AND

          COUNTD ({fixed [xyz],[Complaint],[Product],

          DATETRUNC('month', [Year-Month ]):(product diff])})<= 127

      THEN

      WINDOW_COUNT(SUM({ FIXED [xyz],[Complaint ],[Product ],

      DATETRUNC('month', [Year-Month]):

      (COUNTD([Complaint])}))

      END