6 Replies Latest reply: Sep 23, 2016 1:25 AM by Gysbert Wassenaar RSS

    Count if 0

    Robert Ebner

      Hi all,

       

      i have the following expression:

       

      Datenload:

      LOAD

      Alter2,

      count(Proben_ID) as Anzahl_Warteschlange

      Resident Datenload_Datum  Group by Alter2;



      How can I get also counts with 0?


      Thank you for your help!


      Robert