15 Replies Latest reply: Aug 11, 2016 12:38 PM by Phaneendra Kunche RSS

    it only counts the value once

    Robert Winkel

      I have an app that part of the data comes from excel files and part is a direct connect.

      I used the expression below on a total direct connect to count all like data in the field and it worked but when I us the same expression in my new file it only counts one DeaClass C-II per NDC.

       

      count({<DeaClass={'C-II'}>}DeaClass)

       

      The data below is after I removed all duplicates from the excel data file.

      I am converting file from excel to direct connect desktop to enterprise.

         

      NDCDeaClass
      00054023525C-II
      00054023625C-II
      00054023763C-II
      00054023863C-II
      00054024425C-II
      00054026425C-II
      00054026525C-II
      00054038663C-II
      00054040444C-II
      00054040450C-II