COUNT IF DIFFERENT

[arun2305]

Hi,

I am trying to count a range of value if it's different then the value 'OF CLOS' that is in other column.

Count(DISTINCT If(([OF CLOS & OF OF OUV]<>'OF CLOS'), [Nº rés. & Pos _ Base _ Duplicata]))

It's the symbole <> that isn't working.

Thang you in advance for your help.

Best regards, Arun

[JordyWegman]

Hi Arun,

What do you mean with a range of values? Can you show us a screenshot of the table?

The If should be outside of the count statement.

IF(
     [OF CLOS & OF OF OUV]<>[OF CLOS], 
     Count([Nº rés. & Pos _ Base _ Duplicata]
)

Jordy

Climber

[arun2305]

Hi Jordy,

It's not working...

The result is this '-'

[David_Capan]

Hello Arun,
Try using this set analysis expression instead of an IF statement
Count(Distinct {<[OF CLOS & OF OF OUV] -= {'OF CLOS'}>} [Nº rés. & Pos _ Base _ Duplicata])