Formula Editor errmsg: The remaining text does not appear to be part of the formula

The below function returns the errmsg in my question title, and the cursor is in the line above FinalResult;

stringVar FinalResult;
FinalResult := '';

if ({spr_single_broker_history_summary;1.quarter_id} = '999999') then
    FinalResult := 'Grand Total'
else if ({spr_single_broker_history_summary;1.quarter_id} = '999998') then
    FinalResult := 'Total for last four quarters'
else
    FinalResult := Picture(Cstr({spr_single_broker_history_summary;1.quarter_id},0,""),"xxxx Quarter x")

FinalResult;

Thanks in advance.
-Jim
LVL 66
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorAsked:
Who is Participating?
 
bdreed35Commented:
It looks like you need a semi colon after the last line of the If statement:

else
    FinalResult := Picture(Cstr({spr_single_broker_history_summary;1.quarter_id},0,""),"xxxx Quarter x");
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorAuthor Commented:
That was it.  Thank you.  -Jim
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.