Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
Looking for help below:
I'm having list box like below as calculates expression
=if (not isnull(PLANT),PLANT & ' - ' & NAME1)
Here PLANT = Plant numbers and NAME1 = Plant Description.
How to show values in the list box starting with 5* along withdescription?????
Thanks,
AS
Hi
=if(Left(PLANT, 1) = '5', PLANT & ' - ' & NAME1)
This will also exclude nulls
HTH
Jonathan
Hi
=if(Left(PLANT, 1) = '5', PLANT & ' - ' & NAME1)
This will also exclude nulls
HTH
Jonathan
Jonathan,
Thank u for your help.
Just want to ask you one more thing , Suppose I do have some plant number(i.e PLANT) not having description (i.e. NAME1) , so is there any way to show only those Plant numbers having description in list box????
Thanks,
AS
One more check would help there. May be like:
=if(Len(Trim(NAME1))>0 and Left(PLANT, 1) = '5', PLANT & ' - ' & NAME1)