Highlighting repeated values in straight table

[manuelrubiano]

Hi community, I would appreciate some help.

I have a model with two tables:

I need show the data in a adhoc table. when I add the fields from Tab1 only, the key value is unique in each row:

But when i add the field col4 from Tab2, some key values are duplicated. I need mark the key values duplicated (with a background color) only when the col4 is added:

Is this possible?

Thanks.

[jbhappysocks · Accepted solution]

Hi

if(IsNull(col4),null(),

if(count(total <Key> {<col4=>} col4)>1,red(),null()))

[manuelrubiano]

It works. Thanks.