Craig Wright
Technical User
The following formula works according to Crystal's formula checker but when I use it the formula to group in Crystal the error message is: Start position is less than 1 or not an integer
if instr({table_date.balance_accrual},"Accrual","1")>0
then "Accrual Loans"
else "Other"
I will be adding more "if instr"s after the current else in case that influences the answer.
I've searched the instr posts but nothing I've found or tried seems to resolve this issue. I'm guessing it is a relatively basic syntax issue, but I can't find the issue.
if instr({table_date.balance_accrual},"Accrual","1")>0
then "Accrual Loans"
else "Other"
I will be adding more "if instr"s after the current else in case that influences the answer.
I've searched the instr posts but nothing I've found or tried seems to resolve this issue. I'm guessing it is a relatively basic syntax issue, but I can't find the issue.