16 Replies Latest reply: Jan 10, 2017 9:34 AM by Stefan Wühl RSS

    Simple count is not working properly

    Twan Peters

      I have a simple table with only 4 fields and I want to calculate the distinct consumers that have an 'EmailTypeSent' = Welcome*.

      This is working fine untill i filter in the EmailTypeSent on another value than Welcome*.

       

      As is shown in the image, when i select 'Other' it still gives a 2 as count. However, it should give 0, because there are 0 email addresses in the filtered table with an 'EmailTypeSent' = Welcome*.

       

      What is wrong with the used formula? The table shows the right records.

       

      =count(DISTINCT{<EmailTypeSent={'Welcome*'}>} EmailAddress)