Hi

 

I try to select names wich are displayed only one time.

So I use a formula for duplicates like this one :

 

let myV := 'Bird name';

if cnt(select 'table name' where 'Bird name' = myV) > 1 then

"Duplicate"

else

"no duplicate"

end

 

But that displays the duplicates one time but not the names that are alone.

 

If I have 3 Aras :

Ara vert

Ara rouge

Ara bleu

It will display "Ara" one time, good !

 

But if I have :

Amazon

Eagle

> only one Amazon and only one Eagle : they will not be displayed because there is no duplicates of Amazon neither Eagle.

 

My question will that issue be resolved if I enter "greater or equal" instead of > "greater" ?

= myV) > 1 then

Why don't you try yourself could you say ?

Because I am working on an Ipad and there is no way to enter that double math symbol unless may be if I buy a bluetooth keyboard but I should be sure it will work !

Thanks