What is the problem with my code all the other with ewt is already not shown but still there is one that is showing
i already fix this hahhahaha
=IIf(InStr(Trim([GLTran.TranDesc]), 'EWT') > 0 OR [GLTran.TranDesc] = 'EWT FOR 4TH QTR 2022_DAP' ,'', [GLTran.CreditAmt] - [GLTran.DebitAmt])
Best answer by darylbowman
One of the ‘InStr’ functions (either GI or Report Designer) returns 0 when it doesn’t exist, and one returns -1. It may be that you need to use >= 0 depending upon where you’re working.
+15One of the ‘InStr’ functions (either GI or Report Designer) returns 0 when it doesn’t exist, and one returns -1. It may be that you need to use >= 0 depending upon where you’re working.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
