Parse Error at char(0): Parse Error

[Skander]

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

[DiganP · Accepted solution]

@Skander 

It would just be IF [PolicyNumber]=[Row+1:PolicyNumber] THEN 'no' ELSE [Answer] ENDIF

You don't need the equal sign in the front. 

[Skander]

Amazing! Thanks!

[Prasadh]

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?