6 Replies Latest reply: Jun 4, 2018 2:26 PM by Elizabeth Viso RSS

    Counting Data and excluding multiple items

    Elizabeth Viso

      Hello,

       

      I need to count how many inspections ([Bascom InspectionFrequency]) are monthly with distinct barcode numbers ([Bascom Barcode]) and do not have _R (300126_R) at the end of the number.

       

      So I currently have this:

       

      Count({<[Bascom InspectionFrequency]= 'MONTHLY', [Bascom Barcode]>} [Inventory Bascom Barcode])

       

      But it's over counting and every time I try to exclude the barcodes numbers ending in _R I get an error.  Any ideas?

       

      Thank you!