Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI All
i have try
=if(sEG='A11',sEG)
it can display those A11 company.
may i know how to change the above expression to list missing value ?
i Try :-
=if(sEG=' ',sEG)
it does not work
paul
try,
if(len(trim(sEG))=0,sEG)
I don't understand one thing here; if sEG is missing/null() then why are you trying to return sEG?? it will always return a null value, return some other field
if(Isnull(sEG), otherfield)
or
if(Isnull(sEG), 1,0)
Can you explain the objective for more clarity?
Thank you it work now.
Paul Yeo
DIrector
TDS Technology (S) P/L
Whatsapp +659:261804