Color Coding Based on Calculation

[hammermill21]

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.

[sunny_talwar · Accepted solution]

How about this

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

[hammermill21]

Thank you, I see what I missed