Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody,
I want to know how i can do if dont wildmatch
Here my example : i want to have 1,7 as Seuil_Z1 if [Clients Emeraude] <> '0'
if(WildMatch([Clients Emeraude 1],<>'0'),'1,7') as Seuil_Z1,
If someone have a reponse.
Thanks
you can use not
if(not WildMatch([Clients Emeraude 1],'0'),'1,7') as Seuil_Z1,
but i think is better
if([Clients Emeraude] <> '0', 'something', 'something else') as .......
Hi feneman,
if I understand correctly your requirement, you just want to query if the field [Clients Emeraude] has some value other than 0.
You don't need a WildMatch to do that, though. A simple IF() query will suffice for that.
(you'd need WildMatch to find out whether that field has one of n particular values)
HTH
Best regards,
DataNibbler
you can use not
if(not WildMatch([Clients Emeraude 1],'0'),'1,7') as Seuil_Z1,
but i think is better
if([Clients Emeraude] <> '0', 'something', 'something else') as .......
try
if([Clients Emeraude 1]<>'0' and WildMatch([Clients Emeraude 1],'1,7')>0,[Clients Emeraude 1],0)
Thanks you guys.