3 Replies Latest reply: Apr 4, 2018 11:37 AM by Elizabeth Viso RSS

    Table Counting Based on Answer

    Elizabeth Viso

      Hello,

       

      I have a table that has an inventory count, then a count of a pass and failed. To calculate the Pass or fail I'm using this:

       

      Count({<[Bascom Pass]={'YES'}>}[Bascom Pass])

       

      Count({<[Bascom Pass]={'NO'}>}[Bascom Pass])

       

      But my problem is that it gives me the total for all the inventory item instead of breaking it down. When it should be For example for Exit Lights, Passed 295 and Failed 3. I've tried a few ways and nothing seems to be working.

       

      Capture.PNG

       

      Can someone help