I have import a GL Table into QV .
I want to change all the GL CODE number 10026 , Now it have many other number.
I try :-
if(@1:16T='','10026') as GL_CODE_NEW1,
it does not work , as it return nul value.
Hope some one can advise me.
Enclosed my QV doc
If(Len(Trim(@1:16T))=0, '10026') as GL_CODE_NEW1,
thank you work now
Retrieving data ...