Condition

[master_student]

Hello Guys,

I need to set a condition if Fournisseur is empty like bellow then, display the values of another filed :

I create this condition =if(Fournisseur =' - ', PO_FOURNISSEUR_BCOUV) but i get nothing as a result knowing that PO_Fou:

[YoussefBelloum · Accepted solution]

Hi,

usually if you make an export and see this '-', this means that it was NULL.

try this:

=if(len(trim(Fournisseur))=0, PO_FOURNISSEUR_BCOUV,Fournisseur)

[master_student]

Thanks youssef, you are right

[YoussefBelloum]

You're welcome