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

[MarqueeCrew]

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

[DiganP]

@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?

[Skander]

[Skander]

[Skander]

Hi both,

Please see above some screen shots, hope it's helpful.

Many thanks for your help,

Skander

[DiganP]

@Skander Get rid of the equal sign in the multi-row formula tool! this should do the trick.

[Skander]

I should replace the equal sign with something else right?

[DiganP]

@Skander No, you don't need the equal sign! just the conditional statement. 

[Skander]

Would this be the formula then?

=IF [PolicyNumber][Row+1:PolicyNumber] THEN 'no' ELSE [Answer] ENDIF