Parse Error at char(0): Parse Error

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

Error Message

Accepted answers

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

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

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?