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

    Counting Data and excluding multiple items

    Elizabeth Viso



      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!