Hi,
I am trying to identify the latest status for a policy by using a Multi-Row formula.
Formula =IF [PolicyNumber]=[Row+1:PolicyNumber] THEN 'no' ELSE [Answer] ENDIF
[PolicyNumber] is a V string
The following error is displayed:
Error: Multi-Row Formula (6): Parse Error at char(0): Parse Error
Thank you in advance for your help
Solved! Go to Solution.
it would help to see data....
first thought is that formula could include that = sign.
=if should just be IF
second thought is that last record will be compared to EOF and that could be a problem.
it's a start.
cheers,
mark
@Skander Make sure the data type in the multi-row formula tool is set to a string rather than Int 32 (by default). This should do the trick.
If this doesn't work, can you send a screenshot of the Multi-Row formula tool?
Hi both,
Please see above some screen shots, hope it's helpful.
Many thanks for your help,
Skander
@Skander Get rid of the equal sign in the multi-row formula tool! this should do the trick.
I should replace the equal sign with something else right?
@Skander No, you don't need the equal sign! just the conditional statement.
Would this be the formula then?
=IF [PolicyNumber][Row+1:PolicyNumber] THEN 'no' ELSE [Answer] ENDIF