If condition not respected

[#1]

Why my if condition it's not respect for some values.

My condition:

=Count(if(RaiserPlantID = Responsible, REA,))

I've 349 when i only should have 347.

At the moment what is selected:

RaiserPlant = 351E

Why this 2 are showed if raiserPlantID is different from Responsible as you can see in the pic

[its_anandrjs · Accepted solution]

Try with

=Count(if(Trim( RaiserPlantID ) = Trim( Responsible ), REA ) )

[#3]

or try with:

count({<RaiserplantID = {$(=Trim(Only(Responsable)))}>} REA)

best regards.

[#4]

You save my day, thanks i hope some day i can retribute