Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
How about this
If(Count({1}DISTINCT BarcodeI) - Count(DISTINCT{<Pass= {'YES'}, Barcode>} Barcode) > 0, LightRed(), RGB(160,160,160))
How about this
If(Count({1}DISTINCT BarcodeI) - Count(DISTINCT{<Pass= {'YES'}, Barcode>} Barcode) > 0, LightRed(), RGB(160,160,160))
Thank you, I see what I missed