Count distinct OR

[daaha_92]

Hi everyone,

I have an count expression that works really well in a table;

Count(DISTINCT {$<Punten={'GeenEis'},JaarBehaald={'GeenEis'},JaarOpgestart={'GeenEis'},leervak={'GeenEis'}>} KEY )

My problem is that i have 3 columns;

Column1  contains 'J' or 'N'

Column2  contains 'J' or 'N'

Column3  contains 'J' or 'N'

I only want my expression to apply to the lines where Column1 = 'J' OR Column2 = 'J'.

At this moment it applies to all 3 columns,

Any idea how i can do this?

Thank you so much in advance,

[sunny_talwar]

Not sure how you expression is linked to these conditions? Would you be able to provide some more details and/or a sample?

[Shax]

Put "+" instead of "OR".