Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi Jordy,
It's not working...
The result is this '-'