2 Replies Latest reply: Jul 11, 2018 3:26 PM by Elizabeth Viso RSS

    Color Coding Based on Calculation

    Elizabeth Viso

      Hello,

       

      I'm trying to color code based on my expression:

       

      So if my expression:  =Count({1}DISTINCT BarcodeI) - Count(DISTINCT{<Pass= {'YES'}, Barcode>} Barcode)  equals more tahn 0 I want it to be read. I've tried a few things but it's not working.

       

      I tried:

       

      if(sum(Count({1}DISTINCT BarcodeI)-Count(DISTINCT{<Pass= {'YES'}, Barcode>}) = '>0' , lightred, RGB(160,160,160)))

       

      also

       

      if(Count({1}DISTINCT BarcodeI)-Count(DISTINCT{<Pass= {'YES'}, Barcode>}) = '>0' , lightred, RGB(160,160,160))

       

      I'm obviously doing something wrong since it's not working.