Hi there, I think this is a bug too that the formula of “InStr” return the different value with G.I.
In G.I., I use “InStr” formula to find the text position and return 0 if it dosen’t exist. It is correct. However when I use “InStr” formula in Report Designer, it return -1 if the value dosen’t exist. It shouldn’t be correct.
Is anyone can give corrective advise or point out what is the problem? Appreciate & thank you in advance.
I believe this is an inconsistency between the Report Designer and GIs. I can confirm having the same experience in the past.
I believe this is an inconsistency between the Report Designer and GIs. I can confirm having the same experience in the past.
Thank you so mcuh for your feedback and sharing.
However, it shouldn’t be correct. It is because “InStr” is a very general function in any scripts. It doesn’t ever have -1 result normally. I do not know why Report Designer come to the first case with this result. It is absolutely inconsistent with “InStr” common concept and logic.
Besides, G.I. and Report Designer are both under Acumatica system, the formula should be under the same concept and logic too. Otherwise, it should be a unequal bug in my opinion.
Hi
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.