Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
Not sure how you expression is linked to these conditions? Would you be able to provide some more details and/or a sample?
Put "+" instead of "OR".