4 Replies Latest reply: Mar 7, 2018 10:03 AM by Ramzi Manoubi RSS

    Set analysis ignored, when table empty

    Ramzi Manoubi

      Hi,

       

      Any help understanding this is very welcome.

       

      I try to count the number of persons which have at least 1 book.

      count(   {< Book_Id = {*} >} distinct Person_Id    )

       

      Because of a mistake (by me), the table with books is empty.

      In the data model the table "books" appears, with all it's columns, but no rows.

      What I had expected is that the above function would return 0 books, for every person.

       

      In stead, the functions operates similar this function:

      count(  distinct Person_Id    )

      The set analysis is ignored, because the table "books" is empty.

       

      Why? This is not what I expected.

       

      Thank you for your interest.