3 Replies Latest reply on Jul 24, 2018 9:23 AM by Deepak Rai

    LOD Calculation Help

    Paul Brainard

      I have a list of records that have a lot of duplicate information.  For example I have multiple lines with the same Service ID.  The service ID is the unique key and I only want one instance of each so I can get a count of booleans.  The Appr field is the boolean.  I tried this calc:

       

      {FIXED [Service ID] : COUNTD(IF [Appr] = TRUE THEN 1 ELSE 0 END)}

       

      But it seems to be counting all records regardless of the boolean value.

       

      Please, and thanks!!!