Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 648
  • Last Modified:

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
0
Jim Horn
Asked:
Jim Horn
1 Solution
 
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

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now