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 just be IF [PolicyNumber]=[Row+1:PolicyNumber] THEN 'no' ELSE [Answer] ENDIF
You don't need the equal sign in the front.
Amazing! Thanks!
I am getting the same error but this seems more like a data error from the input file as the formula says just contains and the text BI, Can someone help?